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   First time in VBA for Word, how to loop through document Windows XP Pro SP2 Word 2002 SP3 I am new to VBA for Word, but I've programmed extensively with VBA for Excel, so I'm pretty familiar with the VBE and how VBA works in general, it's just that Word presents an object model I'm not familiar with. Anyway... I have a 360 page Word document. There are five Section breaks in the document (Insert/Break/Section Break Type/Next Page), and e... 5 27.07.2006 12:30:53 Getting data from input box into MS Word Form I am using the following Macro to get data from the user via a popup box. How can I then deposit the contents of the variable fname into a form field on the parent document? <code> Sub Getinput() Dim fname fname = InputBox("Enter your name:") End Sub </code> I tried this, where text10 is the name of the form field. I also tried text10.text = fname.: <code> Sub... 3 26.07.2006 20:08:11 FAQ - Frequently Aske Questions - vba - please read before posting - unofficial July 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-... 3 26.07.2006 15:17:37 Retrieving repeatable data from a database Hi There, I've got a quick question that I hope someone here can help put me in the right direction on. I have data stored in SQL Server that I would like to pull into a formatted Word document. Imagine the document having header information and then a table of additional data (kinda like an Access report with a subform) I've taken care of the header data; retrieving it and pus... 3 25.07.2006 11:33:46 Deleting Even Pages Within Page-Range I'm wondering if this is possible, and if someone could provide (or point me to) some sample code that would help me build a macro to accomplish this task... Let's say I have a 200 page document. The first chapter must remain static, but all remaining chapters (defined by section breaks) need to be 'cleaned up' by deleting ALL even-numbered pages. I would like to bind this to a macro to ... 3 24.07.2006 04:12:29 Creating a Userform upon Opening Doc Hi all, I'm totally new to doing this sort of thing so please treat me as a beginner. Basically, I want to create a document / template using MS Word that will be given to various users. The document will contain a page of text with gaps throughout the text that I want to be filled in with users replies. When the document / template is opened, I want a pop-up form to appear. I wan... 4 23.07.2006 14:46:45 Word spacing & Sentence length Hello Everybody, I have two questions about VBA of word. 1. Is there any way to find out and control the distance/space between words as we do with characters (character spacing)? 2. Is there any way to find out the length of a given sentence in points for a given font (as different fonts have different apparent sizes)? Thank you, -- Syed Zeeshan Haider ------------------... 5 23.07.2006 07:55:33 Problems with AutoNew in Normal.dot Hi All, I am getting some frustrating problems with the AutoNew procedure when I use it inside Normal.Dot. I am using Word 10 (XP). I have put the following code into a new module in Normal.dot: Sub AutoNew() MsgBox "You are in AutoNew" End Sub When I open Word I get a new blank document but no code runs in the AutoNew procedure. If I then open a New Blank Document the code ... 7 20.07.2006 02:13:48 Trying to create a word macro to emulate a program called e-cleaner I have been trying in vain to write a Word 2003 macro that would emulate the actions of a little program called e-cleaner. The program can be found at http://ecleaner.tripod.com/clean202.zip. It is freeware and very small in size. The program removes unwanted characters from a document. You can choose the characters you want to remove. After it has removed all unwanted characters it reforma... 2 19.07.2006 14:10:04 Online resources for learning about classes and related programming? I have a conceptual understanding of classes (class=person, attributes include phone, address, birthday, etc., create as many instances as are needed) but I've never programmed any classes. It looks like I need to learn quickly, to revise an old project. Any pointers to helpful FAQs and learning materials would be greatly appreciated. I'd also welcome some general guidance on the following ... 2 19.07.2006 09:25:48 Find/Replace with sequential number Hi, I'm figuring this is probably an easy thing to do...for someone who has a clue. Unfortunately, I don't. What I'd like to do (and I'm using a Mac/Word2004) is this: find 12:00:00 and change it to 12:01:00 (or 12:00:01, doesn't matter) and then the next instance 12:00:02 and so on through 59. Is this possible using MS Word? (I also have Virtual PC, which lets me emulate WIndows ap... 4 17.07.2006 21:57:13 Skip mail merge fields from Excel Workbook when blank/zero I am creating mail merge letters (pay-slips) in Word 2003 from a list of about 300 employee records in Excel. The list has 28 fields and some of the values in some of the fields in the workbook are blank or zero. What I need is that, when a value is blank or zero, then that field (both field name and value) dosen't show at all on the letter so as to make each pay slip contain only data t... 2 16.07.2006 14:28:15 Help please with option buttons Hi, I need to create option buttons in a user form in VBA word. When the user clicks the option button it will add a piece of text with screen shots to the document and then when following the wizard (user form) more text and screen shots will be added when clicking certain option buttons. I've tried inserting autotext to bookmarks but the screen shots are not added (i get an error in... 7 12.07.2006 13:37:10 How to check if a variable exists within another variable Hi, I have 2 variables: A="Fox" B="The quick brown fox" How can I check if variable B contains variable A? Something like: "IF (A is part of B) THEN TRUE" Is that possible in VBA? Thanks ... 5 12.07.2006 11:35:59 Word Macro Problem Is Any one can tell me about this. I have to fetch data from MS-Access into word document by pressing a different keystrokes. Let here is example wht i have to do... In open word document When I press keystroke <Alt>+M...it would retrieve data whose names starts with 'M' from ms-access table ; similarly if i press <Alt>+L...it would retrieve data whose names starts with 'L' ... 9 12.07.2006 09:36:52 HELP PLEASEEEE Hi Guys... I got Spreadsheet with data, may be around 5000 rows and 2 columns. I want to create seperate RTF files from columns, For Example Product code Product info 124585 XXXXXXXXX want to create product code as a file name and product info as a data in file. Any help would be appreciated. Many Thanks ... 2 11.07.2006 16:26:55 Brackets in MW 2002? Hello everybody, I hope this is the right newsgroup for Microsoft word 2002. If it is not, please tell me otherwise. Basically, I'd like to be able to put a bracket around some text. When I say bracket, I mean to underline the text and then have the underscore go straight up at the end of the selected text such that it makes a 90 degree angle with the underscore. Any suggestions? ... 2 11.07.2006 10:06:31 loop through multiple spread sheets I have 6 years of data I would like to process. Each day is saved as its own spreadshhet. They are all saved in one folder; naming convention 08-01-00 to 07-0106. I would like to copy the same cell from each spreadsheet into a new spread sheet. Can some one point me in the right direction please. ... 2 11.07.2006 01:11:29 Remove characters *not* of a specified font size I would appreciate help in writing a macro that removes from a document all characters of any font size other than the size specified in the macro. In the docs I'm working with, these unwanted characters tend to occur in bunches ending with a paragraph mark, so ideally the macro would remove the paragraph mark as well, although this isn't as important. I'm using Word 2003. Thanks.... 12 11.07.2006 00:13:01 Set range = whole document minus last word (conditionally?) I'm unfamiliar with the word object model- I do all my VBA in Excel, but I'm helping someone out with what should be a simple macro. We are currently using [ActiveDocument.SpellingErrors.Count] which gives the count of all the misspelled words in the document. however, if the user is in the middle of typing a word (Inte when spelling Intelligent) then that counts as a misspelled word when t... 6 10.07.2006 19:35:41 Numbering macro without autonumbering Hi, Is there a way to create a macro that numbers each paragraph in a selection consecutively? I would like the numbers to be inserted right before the paragraph mark. Also, I don't want to use bookmarks or fields or autonumbering or a list style. For example, I would like to be able to select any number of paragraphs in a Word file, and have a macro that numbers each one, such as: ... 12 07.07.2006 16:27:54 Wildcard for non-printing characters Hi, Is there one wildcard that would find all non-printing characters, such as spaces and tabs? Or do I need to do a find for each type of non-printing character? I am using Word 2003. I think Word 97 used to have ^w, but that does not seem to work in 2003. Thank you, Amy... 5 07.07.2006 14:25:41 protected document with spellcheck macro not working for others Hello, I seem to be having a problem with a macro I have created in Word 2003. The macro allows the user to run a spell check on a protected form (http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm). I have saved the macro to normal.dot but when anyone else opens the form they get the macro error message that offers some reasons for the macro not running. I do not have a lo... 4 04.07.2006 16:54:31 "Check All" checkbox Hi all I am trying to create a 'check all' checkbox. I have several hundred checkboxes and want to be able to click one master checkbox and have them all be checked with one click. I don't want to set them all to be checked initially though. I thought it might be possible with a loop statement. Any ideas? Gav... 10 04.07.2006 14:32:02 Toolbar buttons keep disappearing Greetings all, I'm a self taught user of Word 2003 and there's a heap I don't know. I like to pick and choose my toolbar buttons but have found that they keep disappearing on me when I go back to use Word later (I haven't checked but I think it is when the computer is turned off that this happens, but can't be sure). Very frustrating - any ideas/suggestions. ... 4 04.07.2006 05:46:22 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