Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Word Macro and Access 1

Status
Not open for further replies.

Telsa

Programmer
Jun 20, 2000
393
US
I have a merge document in Word that merges with a query in Access based on data in a prompt in a macro I wrote in Word.

What I would like to do is from Access, have that document open and run the macro. Two thoughts:

1. If I call this Word macro from Access, how do I reference it after opening the Word document?

2. Or can I have the macro run automatically from the document once it opens????

Any ideas anyone????


Thanks!

Mary :eek:) [sig][/sig]
 
This macro will automatically run upon the opening of the document, assuming that Macros are Enabled.

Sub AutoOpen()

End Sub
[sig][/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top