Threads Replies Last Post 23 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23   Range question I want to add a new paragraph to the end of the document, then change the font size of the preceding paragraph, then add a table after the new last paragraph. I've done this before using the selection object, but would like instead to use the range object. How do I 'locate' the last paragraph? Very bad pseudo-code: MyDoc.Range(end, end) = Add_New_Paragraph MyDoc.Range(end-1, end-... 9 08.02.2006 12:21:48 Isolating Text of a Particular Size and Font I've got what I think are some simple questions. I'd appreciate any help. I have a pretty long word doc that is output from OCR recognition of a help file for Windows Movie Maker. I'd like to make a table of contents for the printed version. The formatting is constant, so here's what I'd like my VBA procedure to do: 1.) Find every instance of Times New Roman size 23 2.) When each ins... 3 08.02.2006 01:16:17 Selection.InlineShapes.AddOLEObject ... causes (wellknown) error, any workaround I have a macro that out of an text file creates a Word doc by applying context sensitive logic and selection. The text file contains sometimes an URL to a server inside our company domain, the URL points to a specific file that shall be inserted into the Word doc. The URL looks like this \\servername.mycomp.com\folder1\subfolder\subsubfolder\aFile.pdf alternative the IP-addr of the serve... 3 07.02.2006 18:13:03 List boxes I have the following code which is meant to take multiple selections from a list box and paste them into a document at the site of a bookmark. I'm not getting the value from the list box correctly. Any help would be greatly appreciated. Public Sub AddPracticeAreas() Dim i As Integer Dim strPractice(10) As String ActiveDocument.Bookmarks("bmPracticeAreas").Select For i = 0 To 9 ... 5 07.02.2006 14:04:27 Change a name (from a list in a txt file) on a document, then print it. Dear all, I am new to word scripting and am wondering if there is a quick way to change in a document say the name on a certificate and print it? I have a text file of the names that are to go 1 by 1 on to the cert for printing, and I'm rather confused by examples found via google... I suppose I need to put a field at the place where the name should go and have a macro / script replac... 4 07.02.2006 07:30:42 Insert footer in last page using VBA How can I put text into the footer of the final page using VBA ? I can do it manually using: { IF { PAGE } = NUMPAGES "Text here" } } But I need to do it with a macro Thanks hals_left ... 13 06.02.2006 20:03:12 Extracting range from Section Hi, I have a document that contain a lot of sections. Each section starts with an 4 characte identifier, which I would like to extract. Now I would like to iterate through the sections, but receive a compiler error (wrong number of arguments) Dim oSection As Section Dim oRange as Range For Each oSection In ActiveDocument.Sections oRange = oSection.Range(0, 4) 'This is not accepte... 6 06.02.2006 16:28:12 VBA equivalent to Enum in C Is there anything similar to the enum statement in C? Eg, I can have four constants defined using this statement (if I remember my C correctly): enum {NONE=0, TEST=1, ERROR=5, RETRY=7}; ... 3 06.02.2006 13:43:35 VB Code to create folders Hi Does anyone have any VB Code that can create a folder if it does not exist? Perhaps C:\temp ? And if it does exists, don't do anything. Where can I look for code like that? ... 2 04.02.2006 13:54:48 (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 04.02.2006 04:20:13 (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 04.02.2006 04:20:12 copying excel cells as image in word with a macro Hi there, I need to insert Excel Cells as images in a Word Document. Is there any way to do it ? thx everyone -- Ciccio_DrinkPosted from - http://www.officehelp.in ... 2 03.02.2006 14:33:47 template change I created a new template based on an old template (same file name). I have renamed the command buttons so the code is easier to read (in the old template they were left at default CommandButton1, etc.)and added in some other functionality. Now I have a fully functional template for any future documents based on this template and it works fine. I didn't realize when you open a document based o... 3 02.02.2006 16:21:31 Form Fields Is it at all possible to create a double drop down from field .... I am trying to create a drop down that will narrow the choices to the second drop down.... Example : If you choose chocolat then the second drop down will not have any pepper and salt to it Thanks for your help ... 2 02.02.2006 02:10:42 Using a VBA Form to Update doc props Hi Folks, I'm trying to use a UserForm to: a) display the current document propoerties (e.g., Title) b) capture and update user entered properties I'm able to update the document Title with the following code but I am struggling to capture the existing Title and display it in the UsearForm. I'm certinly making loads of mistakes - any guidance would be appreciated: >>>>>... 2 02.02.2006 02:05:27 Underline We have a bookmark that we underline as follows: .Bookmarks("proj_coord").Range.Font.Underline = True That underlines the complete bookmark. However, when we enter the text into the bookmark it still underlines the spaces. Here is the code we use the following procedure: Public Sub differentreplacebookmarktext(strBkmk As String, strRep As String) Dim Bmrange... 3 01.02.2006 21:27:49 Very dumb question about initializing combo box that uses array Here's the code I'm using to populate some very simple comboboxes with hard-coded items: Private Sub ComboBox1_Change() ComboBox1.List = Array("Functional", "Look and feel", "Usability", "Performance", "Operational", "Maintenance", "Security", "Legal", "Other") End Sub Private Sub ComboBox2_Change() ComboBox2.List = Array("1", "2", "3", "4", "5") End Sub Private Sub ComboBox3_Cha... 10 01.02.2006 04:19:40 pulling text from a word document I have a word document that contains a four-column table. The first two columns contain a Task ID and a Description of Task. One row of the table will have something like the following for Task ID and Description cells. 1.1 Use the 'Export' bat file to export projects. Copy exported projects to the following folder: L:\nBalance\Prod\BlackrockToSimcorp\Position\admin I need to be... 3 31.01.2006 21:09:08 Macro for adding a sequential number to a template I have a Word template for work orders that I would like to be able to have a sequential number generated and inserted when I need it and not have it automatically inserted every time I open it. I've look in a number of places but it seems something this simple is not discussed. Any ideas or help would be greatly appreciated. Thanks. ... 15 31.01.2006 17:14:06 run macro when user clicks on link Hi. I want some sort of hyperlink effect with macros. That is, when a user clicks on a hyperlink, i want instead a macro to run and have the macro know which link is clicked (so I could activate a third-party COM DLL). So basically i want to handle an onclick event with macros. I manged to do this in powerpoint because there exists an "Action Settings..." But how do I do this in Wor... 2 30.01.2006 22:07:27 Creating Docs and Saving to DocsOpen only shows correct Attached Template for user who created the doc Sorry for the length of this message, but I am in a real bind here. Hopefully one of the experts out there has worked with DocsOpen and can help with this problem. I have a question relating to using the "default" templates location in Word when using a DMS such as DocsOpen. The default location recommended by Microsoft (and set by default when Office is installed) is the user profile ... 3 30.01.2006 17:23:27 I am looking for a course Hi, I am looking for a free downloadable course/tutorial/manual/guide on VBA for beginners. I need something which could teach me step by step (with examples) how to use VBA - first of all with Excel97 or later. All links I have found in the Google point to pages which do not exist anymore or advise to buy a book. Regards, EZ... 3 28.01.2006 17:55:57 VBA & Web Pages Hello, I want to be able to open a web page with a given url, then copy its contents (either all or designated by some keywords which could be searched for), and paste them into my word document. I have searched a lot, but haven't found how to do the above. Any help will be greatly appreciated. Thank you. PAntojee -- pantojeePosted from - http://www.officehelp.in ... 2 28.01.2006 07:48:45 Using ADO to populate a List Box Hello, I'm a little new to using VBA to access other applications but I'd like to populate a list box in a VBA user form with a column of names from a field in Access. I opened the connection fine - it's just that I'm not sure how to get the information (just a list of names) into the list box. Thank you in advance for any help you can provide.... 11 28.01.2006 02:16:51 End of document marker? Hi All, I need some help with some code that sometimes works and sometimes enters an infinite loop. Using the 'find' feature in Word, I want to find selections highlighted in either red or turquoise. Depending on the color of the highlight, I increment a counter either full value or half value. Sometimes it works, sometimes it just keeps looping. I think the basic problem is that ... 28 27.01.2006 17:44:54 23 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23