Deploying my VBA scripts to the enterprise

[BrianHoard]

After creating several Word VBA scripts and a custom ribbon, a team of editors are eager to start using them. Before I create an installer, I would like to get any expert advice from those who have done this before. Here is my current plan, but I'm sure it could be improved.
- I created a Ribbon.dotm file that contains my ribbon, custom icons and buttons, that calls VBA scripts from a second Scripts.dotm file.
- My thought here is I can easily update the Scripts.dotm file without having to update the ribbon. So far, this is working well.
- I have the few editors who beta test these scripts manually copy these 2 files from my network share to their local folders at %appdata%\Microsoft\Word\STARTUP.
- Now that we're ready to add many more people to the list of users, I'm thinking instead of instructing people how to copy these files, I'll make a Windows .bat file that does that. And instruct them to copy this shortcut to their desktops.


- Then, when they click on this shortcut, it will execute my .bat file on the network, where I can change, modify, and keep it updated to do whatever I want them to do. Like check if they have the latest version of the files, create the STARTUP folder if needed the first time, allow them to select from previous versions of the scripts, etc.


I would love to be able to provide a file they could download from the intranet website, but I'm pretty sure the firewalls will not allow any .bat file to be executed.
Maybe there is a way to achieve that?


Does this sound like a solid plan?

Thanks for any advice.