Launch Word template in Word application, not Internet Explorer

Launch Word template in Word application, not Internet Explorer

Post by Sue » Sat, 29 Aug 2009 22:32:18


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.yqcomputer.com/ ) 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!
 
 
 

Launch Word template in Word application, not Internet Explorer

Post by Sue » Sun, 30 Aug 2009 00:48:38

I should add...if I'm unable to manipulate the templates with code, my
suggestion to my customer will be to put an instruction sentence prior
to their list of hyperlinked templates that reads:

"Right click and save to desk top..."

:-)