S
Sue
I have several Word templates with VBA coding that are required to be
uploaded to our Intranet and launched via a hyperlink. The problem is
none of the macros or userforms work as the template opens in IE - not
the native Word application. I have read about how to change IE
(http://www.shaunakelly.com/word/sharing/OpenDocInIE.html) but I have
hundreds of computers at many locations across the country to contend
with.
I have read about adding JavaScript to the HTML page, but my company
uses a content management system and gives the power of authoring
Intranet pages to people unable to understand how to make that change.
I am looking for some ideas to include in the actual Word template.
I'm thinking of some code that runs right away that says "open the
Word application, then proceeed". I did come up with this:
ActiveDocument.RunAutoMacro wdAutoNew
Not sure how to use it. Would this be a correct way to use it?
Public Sub AutoNew()
ActiveDocument.RunAutoMacro wdAutoNew
UserForm1.Show
End Sub
I appreciate any suggestions! Thank you all!
uploaded to our Intranet and launched via a hyperlink. The problem is
none of the macros or userforms work as the template opens in IE - not
the native Word application. I have read about how to change IE
(http://www.shaunakelly.com/word/sharing/OpenDocInIE.html) but I have
hundreds of computers at many locations across the country to contend
with.
I have read about adding JavaScript to the HTML page, but my company
uses a content management system and gives the power of authoring
Intranet pages to people unable to understand how to make that change.
I am looking for some ideas to include in the actual Word template.
I'm thinking of some code that runs right away that says "open the
Word application, then proceeed". I did come up with this:
ActiveDocument.RunAutoMacro wdAutoNew
Not sure how to use it. Would this be a correct way to use it?
Public Sub AutoNew()
ActiveDocument.RunAutoMacro wdAutoNew
UserForm1.Show
End Sub
I appreciate any suggestions! Thank you all!