How to

[unclesvenno]

Heya,

I have an MS Word document which I have linked to an html page via the following HTML code:

<a href="S:\blah\...\toClient v3.0.doc" target="_blank">

The MS Word document (toClient v3.0.doc) has a VBA Form which loads on the "Document_Open()" event. This works fine if the user saves the document to their desktop and re-opens it. But it fails to load the VBA Form if the user selects the "Open" option.

I've marked the MS Word document as a read-only file because it is a shared template. BTW, I have not created it as a template (.dot) because, instead of creating a new instance of the template it opens the template for editing!

I see 2 possible solutions:
1. to disable the "Open" option from the file download dialogue box?
2. to write some HTML which will open an instance of a template, ie "toClient v3.0.dot"?

Would love some assistance (code samples or better ideas) on this.

Many thanks,
Uncle Svenno

 

[mp9]

Try your code in the DocumentChange event instead of DocumentOpen maybe? DocumentChange fires when a new document is created, when an existing document is opened, or when another document is made the active document. Worth a try anyway.

http://www22.brinkster.com/accessory/