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   VBA Involving Paragraphs Hi. I wonder if the following is possible in Word, using VBA. I have approx. 20 different paragraphs of text on the same Word doc entitled Core.doc. Can I identify each of these paragraphs with a distinct name, such as Paragraph1, Paragraph3, etc. and then compose a type of listbox from which to select several of these paragraphs, and have my "combination" of chosen paragraphs then copied i... 6 18.08.2006 11:21:49 Please Help: VBA Code to Append File Hi. I am new to using VBA with Word. Is there a way to append all the contents of Word File "B" to the end of Word File "A" and then save the newly appended file as Word File "C"? And can this be done without the files involved actually being visibly open? For instance, if a Word doc is open, I'd like the VBA code to take the file C:\Donations\July.doc (not active, open) and append it... 3 18.08.2006 11:13:59 RE: VBA & Bookmarks Greetings, I am fairly new to this concept, so I will give the scenario and the the problem. I have 3 word documents; letter1.doc, letter2.doc, letter3.doc In each of these three documents I have a text form field called 'job number'. Can I write a VB program that will ask a user for a job number, and then insert that number in each of the three documents, if so, how? Thanks. -... 7 17.08.2006 23:49:22 Create EXACT Duplicate of Current Doc - Inclyding pictures and tab I've got a Word 2003 document that contains a lot of embedded pictures and tables. I'm trying to write a macro that will make new document that is an exact duplicate of the first couple of pages, down to the formatting and containing all the pictures and whatnot. Below is the code that grabs the first couple of pages. However, it doesn't seem to work right: Set objDoc = ThisDocument ... 4 17.08.2006 16:08:01 filesearch! Sub a1() With Application.FileSearch .LookIn = "C:\" .FileName = "1.txt" If .Execute > 0 Then MsgBox "There were " & .FoundFiles.Count & _ " file(s) found." For i = 1 To .FoundFiles.Count MsgBox .FoundFiles(i) Next i Else MsgBox "There were no files found." End If End With End Sub The results are "1.t... 2 17.08.2006 12:18:02 deploying Word macro I have a Word macro that I use, and some other folks have expressed an interest in using it as well (non-local, non-networked users some of whom have very little technical skill- we all volunteer for the same national organization). I've reviewed the FAQ and searched google, but while I'm sure the information is out there somewhere, I haven't found it (at least not phrased in a dumbed-down wa... 4 16.08.2006 14:47:37 Formatting pictures and text Hello. I am rather new to all of this, so please be patient... I am a technical writer and try to create a macro that inserts icons, formats the icon, and indents the text. I think i've figured out how to insert the icon and format it. My problem is indenting the paragraph that goes with the icon. So for instance (Note being used instead of icon): Note: This is a sample paragraph. I'm ... 4 16.08.2006 03:55:46 Auto copying VBA code I have a document that contains a button that the VBA code goes out to a database and collects a unique number. Then it returns the number to the document as a unique ID. I am having an issue that when I copy the button over to a new document that the VBA code is not being carried over. Is there a way to automatically set this up to copy the code from one document to another as I copy ov... 4 15.08.2006 19:21:55 concatenate two table cells- get rid of extra hidden chars? I am cycling through my documents concatenating the contents of two cells (cell.range) in each row of source tables. I do so by taking left(Cell1.text, len(Cell1.text)-2) & Cell2.text This does put both cell contents together, but it leaves me with an extra hard return between cell1 and cell2 (cell2 text starts on a new line in the destination cell). I then copy/paste these cells to Excel, ... 5 15.08.2006 17:06:13 Template VBA in document I open a template with VBA-code and close and save the template as a document. When I open the saved document i'm losing the VBA-code. How can I use the VBA-code when I re-open the saved document. Jan ... 2 15.08.2006 09:27:14 Copy array into text file Hi, I would like to find some array in a word document and to copy them into a txt file (with tab instead of cell of course). My input point is a text file with name of array to copy. Array are referenced into list of table. How can I do? Thanks beforehand, BR Fabien... 2 14.08.2006 23:49:17 Equation editor Can I create a Macro to translate from symbolic notation in math to text, or vise versa? I would like to be able to type in text in English, and have the macro convert it into equation form, or vise versa. I.E. since Im doing a lot of math, Id like to type in something like "The Integral of f with respect to x - and have it put that into equation editor using the proper symbols. ... 4 11.08.2006 17:27:31 Problem with "localization" Hi, I have problem with my template and localization. I made my template with form in my regional settings which are "slovak" and when I change my regional setting and all language settings to russian and I want to take some strings from form to my document, specific slovak char like š, č, í etc. display in Russian alphabet (in form are displayed normal in slovak), but others display ... 4 10.08.2006 09:48:15 Could I use a Macro in this situation? I have a 200+ page document I pulled from the Internet. The website used a format of {i} {/i} to italicize sentences. I was hoping to write up something that could automatically find {i} and italicize everything after it until {/i} comes up. Please let me know if a Macro could do this or if there was another alternative. I have some experience with VBA in Access but a KISS solution is pref... 3 09.08.2006 17:43:17 Closing Word without the prompt to save changes I am using an Access db to populate a word document, print it, and close it. When it runs, the user should not be promted to save changes when the document closes. The code includes objWord.Documents("timesheet.doc").Close SaveChanges = False and works on the win2000 server but the win2003 server prompts the user to save changes. The following line works on our 2000 server (Office 10), w... 5 09.08.2006 16:23:00 printing to multiple printers with macro? Is there a macro that I could write that could print a MS word file to one printer, and then also print it to another printer . Both printers are remote / network printers ... 6 09.08.2006 13:04:41 FAQ - Frequently Asked Questions - vba - please read before posting - unofficial August Posting FAQ = Frequently Asked Questions - brief - vba - unofficial This FAQ is posted every ten days or so. Please save us all some time by reading it before posting to the news group. This newsgroup is about VBA - Visual Basic for Applications - which is the programming language for Word 97-2003 (macros). There is a longer FAQ with more questions and links that is regularly posted in the non-... 1 07.08.2006 16:43:30 VBA to re-size all (inline) images in a document? I need to regularly copy/paste records from a proprietary net-based program, into Word. The records include a mix of text and, at irregular intervals, images of various sizes and shapes. The problem is that, although the images are inline, many of them are oversized, extending well beyond the margins. (I realize this may sound unusual, with inline images. It might have something to do with ... 15 07.08.2006 15:27:34 Need Word VBA Help to Create Bmp Hi. I have a Word doc which consists of of some paragraphs of text, tables, and a few inserted pictures. The contents of this Word doc are constantly changing. My aim is to copy all of its contents as a single bmp file, and then paste this bmp file into an Excel xls file. The steps I've used to try to do this manually are: (1) Ctrl & A (select all) (2) Ctrl & C (copy) (3) place my cursor ... 2 05.08.2006 09:46:58 File Name Return? I'm working with the Word 2007 beta. Does anyone know if it is possible to get the dialog to return the selected file and path name after a user selects a file in the wdDialogFileSearch dialog? If not, is there an equivalent way to prompt the user for a file name, returning the path and file name? Note - I do not want the code to OPEN the file, only to return the file name.... 2 04.08.2006 08:37:00 FileSearch I wrote several macros in Word 95 and 97 which were searching for files with specific words in the file text, but I cannot convert them into Word 2003 or write new macro in Word 2003 of this type. I cannot insert words for search into the "text or property" property in the FileSearch object: With Application.FileSearch .NewSearch .FileType = msoFileTypeOfficeFiles .Tex... 4 03.08.2006 21:48:12 Loop through document and compare sentences To the group: I want to loop through a document comparing sequential sentences. The code is below. To test this I have copied and pasted sentences so sentences one and two are exact and four and five are exact, yet I continually get a 'They Match' message box through the entire document (thirteen sentences in the test document). What am I doing wrong? Thank you in advance for any assi... 10 02.08.2006 19:42:57 Accepting deletions in a selected area Hello, I use the following code to accept all deletions in the selected area of a document with revision marks: Dim r As Revision For Each r In Selection.Range.Revisions If r.Type = wdRevisionDelete Then r.Accept Next r However, no matter what area I selected, the above code always accepts all deletions in the *entire* document. What went wrong? I use Office XP and Win XP pro.... 2 31.07.2006 12:30:15 Bad Macro Using Win2000, Word 2000 English and Chinese. My supervisor has set up a template file with macros to insert things like preformatted tables, page headings etc. All the macros work on his computer, but one macro won't work on any other computer: the "Alt+A+T". I get a runtime 4198 error when I try to run it. The code stops here: Selection.InsertCaption Label:="Figuree", Position:=wdCap... 8 28.07.2006 00:46:46 named cell I have an embedded excel sheet in my word doc. I wonder if I can name a cell (my totaling cell) in the excel worksheet so that I can use it to update a field instead of hardcoding an r1c1 addr that will change under various conditions? I've looked in Word's format/cells, but it doesn't show anything about naming excel cells. Thanks Joanne... 4 27.07.2006 12:43:57 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