Help Needed - Passing Value from Access 97 to Word 97 Macro 
Author Message
 Help Needed - Passing Value from Access 97 to Word 97 Macro

i'm using Access 97 - Word 97

i have a Mail Merge doc linked to my database.
I'd like to setup up some parameters in an admin form in the database.

like the Name and Location i'd like the newly created document to be stored.

currently i use an autoopen macro in word, but every time i want to rename
or save the document in a different location i have to go into the Mailmerge
template and change the Save As line in the autoopen macro.

Is it possible to pass this information to the autoopen macro directly from
Access 97!

Or.... should i delete the autoopen macro and complete all tasked directly
from Access?

i'd rarther pass these few changeable parameters to the macro if possible!

Please Advise



Sun, 18 Jul 2004 22:14:06 GMT  
 Help Needed - Passing Value from Access 97 to Word 97 Macro
I've managed to solve this.

it seems the best way is to create a word.application object, then any
macros can be created directly from whichever office application you like to
use as the controller.

it seems thought if there are any errors during the object creation, and the
code breaks while word is still invisible, the object remains open at the
stage it reached before breaking!

i think this is solved by added an On Error line to the code to delete the
object and clean up.


Mon, 19 Jul 2004 00:12:40 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Can you pass a table to Word 97 from Access 97

2. Passing Parameters to Word 97 from Access 97!

3. MailMerge from Access 97 to Word 97, value lost

4. Word 97 - Userform within Word VBA macro and exchange of values

5. Help needed with Word 97 macros for forms

6. Open Word 97 from Access 97 HELP!!!

7. Word 97 Macros > Word XP Macros

8. Passing Parameters to a Word 97 Macro from VB

9. Access 97 to Word 8.0 Automation Help Needed

10. Access 97 create a Word 97 letter

11. Word (97) constants in Access (97)

12. Automation seems to hang with Access 97 / Word 97


Powered by phpBB® Forum Software