Threads Replies Last Post 10 Pages: 1  2  3  4  5  6  7  8  9  10   Using Checkboxes to show and hide text in a word document I have a procedural document that has multiple paths that the user can go down depending on what physically happens. I was wondering if there was a way to set up a checkbox at each of these branches where a yes or no question would be answered by using a checkbox to direct the user down the correct procedural path. I found a simple way to toggle text by the example at this site: http://gr... 4 31.08.2006 11:46:02 RE: Opening Excel for editing Hello, I have a Word form that has a user form within. In this user form some data is entered and thus written to another Word form. I would like to open an Excel for and write some data to a cell, how can this be done? Below is a code snippet for the Word document, I would like to write the same data to the Excel document named 'jobs.xls'. Thanks Documents.Open FileName:="C:\!... 2 30.08.2006 03:37:14 Saving Files in word Hello. I realized this morning that a prievous post may not have been clead. = This is what I a trying to do through a word userform. I gather information from the user, this information among other things = = contain two parts to a folder name that will be created. Some of this = information is also transfered into several Word documents. So... I have a folder name that l... 5 29.08.2006 08:39:42 Sending data from one userform to another Hi, I have designed two userforms, one fires the other. I want know if it is possible to send data from the latter to the first userform or call the subroutines of the first userform from the latter Please advise... 9 25.08.2006 12:10:00 Number of Copies to Print I have intercepted the "Print" command to bring up a form on which to add the addresses that a letter is being sent to, so that after printing it, it will also print envelopes. The main address comes from a UserForm and is stored in a CustomDocumentProperty which is then loaded into tbAddress1 when the form loads. tbAddress2 gives a place for another address (for a CC) and cbCCMedicalR... 4 24.08.2006 20:25:34 VBA permission errors Helllo All, I have the following code to copy a file to a newly created folder. JobDirectory = 'c:\Job Files\" JobNumber= 'B 06-100" JobName='Construction" Why am I getting a permission error, this all happens on my laptop, no network. Const OverwriteExisting = True Set objFSO = CreateObject("Scripting.FileSystemObject") objFSO.CopyFile "C:\Job Setup\Project Information.doc... 2 23.08.2006 08:55:47 Word was unable to read this document. It may be corrupt. Hi everybody, I am having a Word document that I cannot open receiving the well know message from Word 2003. Word was unable to read this document. It may be corrupt. Try one or more of the following: * Open and Repair the file. * Open the file with the Text Recovery converter. (C:\Documents and Settings\...\test.doc) The Document form Microsof... 1 19.08.2006 09:00:54 Concatenate arrays? Thank you to all who have helped me on this project so far. One more question... I have a ridiculously long array -- so long Word can't handle it. I tried Group1 = Array ( "A", "B", "C", "D") Group2 = Array ( "E", "F", "G", "H") GroupAll = Group1 & Group2 but it didn't like that... I also tried GroupAll = Array (Group1, Group2) No dice. What do I try now? Thanks JPJP ... 5 17.08.2006 14:02:30 Combo Box Content depending on result of another combo box Is it possible to have the list available in one combo box be dependent on the result of another combo box? For example ComboBox1 Array ( Cat, Dog ) ComboBox2 Array (Purr, Meow, Catnip) or Array (Bark, Wag, Dog Toy) Thanks JGJP ... 8 17.08.2006 02:25:38 Use Combo Box to set bookmark text. Hi, I'm trying to create a document that allows the user to choose text in a drop down and fill that result elsewhere. (We do not want the drop down to show in a printout.) I was looking at the InsertBefore range, but that wouldn't replace the contents if the user changes the selection in the drop down. For example: Choose the animal: DROPDOWN Animal Chosen: RESULT Can you get... 6 12.08.2006 09:59:42 Automatically Insert Date + 3 Hello, I have a MS-Word 2003 document that I send out regularly. The document has the following statement: "Please return the survey form no later than August 1st". When I open the document, I want the sys to insert the current date, plus 3 days later. Example: When I open the document, the above statement reads: "Please return the survey form no later than August 4th." I have ... 8 08.08.2006 18:34:05 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 Force event code to NOT respond I have this problem in all three Office products which I regularly program, Access, Excel and Word. I write event handlers to respond to (for instance) a change event, but my intention is to respond only to changes made by the user. The problem I have often encountered is that somewhere in code I have reason to change the contents of a form control and that also fires the change event. The ... 8 07.08.2006 14:12:28 Help with templates Hello, I need to be able to determine if the activedocument is a document template or just a doc file. I have vb code that I do not want to run if the active document is the dot template. Any way to do this with checking something about the document, or should I use the activedocument.name and just check the last 3 characters for "dot". Thanks, Jim... 4 06.08.2006 23:13:59 Can someone give some pointers for creating a userform? I have a nice collection of macros, so I thought I would start to look into making a userform. Regularly, I need to run a few macros on a group of files. I have created a macro that does this, but I need to go in to in VBA and manually edit the folder to look in and then enter whatever macros I want to run. I've come up with two ideas to do this more efficiently, but I'm not sure how to pr... 5 04.08.2006 13:17:56 Access to ListBox items Hi I have created a Word doc with a userform and listbox. I have initialized the userform to fill the listbox with filenames(templates) from a selected folder. The next step seems straightforward but has me baffled. How do I show a file(template) selected from the listbox and remove the userform. I would be VERY grateful for any pointers or suggestions. ... 3 31.07.2006 15:57:03 Word Form VBA Stripped after sent by Outlook 2003 I have a Word Form which is used by many staff members in our office. It has Routing code in a macro to send oneafteranother to first their Supervisor, and then the Ops Coordinator. A few of the staff when they send their form (using a Submit Button after fillling in the form) , when it arrives at the Supervisor , their Approval Buttons, do not work. Normally the supervise will make... 2 28.07.2006 21:42:25 Userform Combo box Hi apologies if this is really simple but it's doing me 'ead in. I have a userform that opens up with the word file, however; I cannot figure out how to setup a combo box so it contains a list of the bookmarks held inside the word document. my goal is to have a command button that when pressed will take you to the selected bookmark (i don't know how to do this either) Any help wou... 7 27.07.2006 16:05:02 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 users with less screen resolution- resize userform Hello, I have a userform that displays fine on my computer but when a user with less screen resolution`(1024x768) displays it some of the form is hidden. What is the best way to overcome this please? Peter ... 5 26.07.2006 09:30:55 Word UserForm ScreenUpdating Slow I am currently running a VBA UserForm in Word 2000 and 2003. In the userform initialize statement, the template pulls in data from a saved word document that is set up as a table. This table has 7 columns and 66 rows. This list the employees, phone...and other data to be pulled into the document. I recently copied the document that stores employee data and renamed it. I then updated the... 10 24.07.2006 22:40:48 Autopopulation of form 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... 5 23.07.2006 22:43:27 Minimise the userform Hi, Would it be possible to minimize a userform? It seems that I can only open or close it. Please advise. Wai... 2 21.07.2006 23:55:23 Printing 4 up on form but having all 4 be page 1 then 4 of page 2 Is there a way to code a word document to print 4 pages per sheet one page but have all 4 pages be page 1 and then have 4 of page 2 on a sheet, etc.... 5 19.07.2006 16:06:02 If...Then pointers, dates, and other bits Hi, I'm hoping someone will point me in the right direction to find info on this. I've tried looking it up all over the place, but I suspect I'm not using the correct wording to get the right answer. I'm doing a basic letter template with a UserForm to gather the info. As it stands, I've got it working at a very basic "type on the form, load through into Bookmarks" level - but I want to... 4 18.07.2006 18:47:11 10 Pages: 1  2  3  4  5  6  7  8  9  10