Application Follow Hyperlink and MS Word Macro

[Tom Ventouris]

I am opening an MS Word Document using Application.Followhyperlink. from an
Access 2007 application.
I have an AutoOpen macro in the document. (I mention this because the
problem is solved by removing the AutoOpen Macro).

The Word document opens as expected and runs the macro, however when I close
the document and return to Access the Application.Follow hyperlink procedure
runs again and the Word document is reopened. Closing the document the second
time allows me to return to Access.

Until I can resolve this, I am running the macro manually with a shortcut
key.

Any suggestions? I will be posting in the MSWord group as well.

 

[Arvin Meyer [MVP]]

Use the Startup properties of Access to open a form. Then use the Open event
of the form to open the Word document, and close the form. Since the form is
now closed, when you return to Access, it won't fire the Word document macro
again.