Transferring Macros, Modules, and Forms between PCs
Hello!
I just completed a 3 month long project that has a few dozen macros, a module, and 4 forms. The application runs exceptionally well and will revolutionize our reporting system. Basically, when prompted, a userform opens, and there are buttons on each page/layer/level of each userform that run different macros, open different applicable documents or folders, open relevant web pages, paste different auto texts, etc.
However, moving it from my PC to other PCs has been a little challenging. In testing it between PCs, I have been doing this:
In the VBA window within Word, drag the modules and forms to "Project" instead of "Normal"
Save the document with macros enabled
Email the document to another user/PC
Open the document, drag each module and form from "Project" to "Normal"
That works very well. However, I don't want several dozen entry level employees having to work within the VBA window. I can write a "How to" document, and attach the modules/forms to that document, but if there is a way I can have it do it automatically, that would be fantastic and streamlined and save me having to go help half of them with installing it into their Word.
Any help or suggestions welcomed! Thanks!!
Also special thanks to everyone who has answered my dumb questions on here. This is going to save us thousands per month (and they may give me a raise/bonus.. we'll see!!!)
|