Append a Word Macro
I have to deploy an application to 500 users that installs and also create a Word Macro. I know that copying the file to C:\Program Files (x86)\Microsoft Office\Office14\STARTUP will make the Macro available for all users. I thought the issue was resolved until I realized that copying the file will overwrite existing Macros since they are all stored in the file Normal.dotm.
The only other way is to append the exisiting Normal.dotm with the new Macro code using a VBScript but I haven't been able to figure out how to do that. I have tried using Word to append Normal.dotm but it just writes text to it and not as a script to the dotm.
I hope I was able to communicate my question clearly.
Thanks in advance for your help.
EDIT: I should have mentioned. I know how to use a Macro as a global template.
The Macro is stored in a file %appdata%\Roaming\Microsoft\Templates\Normal.dotm which has to be copied to C:\Program Files (x86)\Microsoft
Office\Office14\STARTUP\ so when a user launched Word, the Macro is loaded automatically.
I was wondering if there was a way to use VBScript to create a Macro and apparently there isn't.
Community Chosen Answer
No appending needed, just put the template containing the macro into the Startup folder. It can be named anything you like, but you'd probably want to use a name that identifies its content. If you didn't want to use the Startup folder, you can use any folder you like (how about a network location, so that you don't have to re-distribute it any time that it changes?) and add that location to Word's template location. You'd also have to add that location to Office's "Trusted Locations" but that's easy enough to do, too.
Answered 03/29/2016 by: