| Thread | Last Post | Replies |
|
| Automating Mail Merge in Word | 31 Oct 2006 22:32 GMT | 4 |
I am trying to automate a mail merge in Word. I am using Office 2003. My source document is a Microsoft Excel file. My target document is a Word mail merge document. I have done the steps manually and recorded the following macro:
|
| insufficient memory - ActiveDocument.Fields.Update | 31 Oct 2006 21:54 GMT | 1 |
We have a macro that updates all the fields in a document using the following: ActiveDocument.Fields.Update On larger documents we are getting the insufficient memory error. Is there
|
| Change Bookmarked Text - Keep Bookmark? | 31 Oct 2006 20:08 GMT | 3 |
As a complete VBA novice, I want to overwrite some Bookmarked text with specific AutoText and retain the Bookmark (so I can repeat this Macro if/when rqrd). I have manged so far to generate the following simple code:
|
| data validation | 31 Oct 2006 20:06 GMT | 1 |
I'm designing a questionnaire for a friend as was wondering if you can help me. It is an electronic questionnaire. I was wondering if i could have general tips about data validation i.e.
|
| Rows.Add -> Error 424 | 31 Oct 2006 19:40 GMT | 6 |
Could you tell me why the Mytable2 Rows.Add returns a 424 Error : object required Thanks for your help Sub Tab2()
|
| Vertical scroll bars on user form that is created at runtime... | 31 Oct 2006 19:37 GMT | 2 |
I am having issues creating vertical scroll bars on a user form that is created at runtime. This is the code that I am using... Dim TempForm Dim NewOptionButton As MSForms.CheckBox
|
| Unusual Return Symbol | 31 Oct 2006 19:28 GMT | 1 |
When a user populates a field on a userform and enters a return character, the output displays a square box, is there any way to suppress this character from appearing in the output, yet still display the text on 2 lines? Basically I am not sure what to search for in the captured ...
|
| How to disable macro after saved so it doesn't run when reopened? | 31 Oct 2006 19:08 GMT | 4 |
How do I disable the auto open macro after the document has been executed and saved in a different location so that when that document is opened to view the infomration or make changes, the macro doesn't run?
|
| Macro/VBA to generate and save filenames | 31 Oct 2006 18:14 GMT | 2 |
I would like to generate and save filenames in a unique way something like: Prefix_datetimestamp. Can I do this be recording a macro or would VBA be necessary? Would really appreciate a pointer in the right direction. Thanks,
|
| Radio button to Check Box in Active Document? | 31 Oct 2006 17:12 GMT | 2 |
I guess this is a two part question. 1. Is it possible to send a radio button value (true/false) to a checkbox in the active document? If so....How?
|
| excel to word via vba button | 31 Oct 2006 13:02 GMT | 6 |
I have to write a weekly report data from various Excel data sources. Is there a way to send this report to a word document using VBA code? How do I send only the latest data (by date) to my word document template? I would also like to create a button in excel so that this can be ...
|
| Reading from DB to Array/Variable | 30 Oct 2006 23:33 GMT | 1 |
I'll better start by informing that I'm newbie into DB v/s VB. What I need to do is to read from a different tables in a Access-DB and copy the information into an array or an varibale. For each table there is one array.
|
| customers to fill out data | 30 Oct 2006 21:46 GMT | 1 |
I am new at this, and am looking for a way to send a form for my clients to fill out the necessary lines be able to secure the rest of the form. Please Help JArzt
|
| VBA Word: How to customize a right click menu bar(shortcut menu)? | 30 Oct 2006 20:34 GMT | 4 |
I am new in VBA word. In MS word, I want to customize right click menu bar(shortcut menu bar) on a Hyperlink. I want to change the menu bar(adding new menu item or delete menu item) dynamically based on different text of a hyperlink.
|
| Insert String Based on Combo Box Result | 30 Oct 2006 19:41 GMT | 3 |
Newbie alert! I've got 2 form fields: Dropdown1 & Text1. I want to populate Text1 based on what the user selects in the Dropdown1 field. The text is loaded in 8 strings, myText1, myText2... myText8.
|