#1
|
|||
|
|||
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!!!) |
#2
|
||||
|
||||
Instead of doing all that, simply save whatever document/template the code is in as a new template, then distribute that. Any document created from the template will automatically have access to the code, userforms, etc. in the template. Existing document can be attached to the same template, too, if needed.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks for the response!
I talked to a coworker about what you said, and he pulled up a macro he had written for his department and showed me that he had done just what you said, and showed me how to save the template to run on startup. Thanks so much! |
#4
|
|||
|
|||
I do something like macropod said.
Instead of saving in normal.dotm, I save my macros in the MYMACROS.DOTM file and save and keep in the word initialization folder (Options - Advanced - General - File Locations). Easy to back up and restore. (No need to export/import modules, userforms, etc.). Note that, in order to gain access to the code, you must open the file from the File - Open menu. For backup and easy reference to the code, I also save each individual module / user to a folder. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combining 3 Modules into 1 | Jude24Joy | Word VBA | 5 | 02-01-2017 04:20 PM |
Declaring a variable that is known across modules | Officer_Bierschnitt | Excel Programming | 5 | 11-18-2015 12:28 PM |
Empty Modules | Greg S. | Excel Programming | 2 | 07-30-2013 01:38 PM |
Transferring auto text and macros from one computer to another | cartoonist | Word | 10 | 08-15-2012 04:01 PM |
the saveas macro in excel 2010 is not transferring the macros to the new workbook | missmr28 | Excel Programming | 3 | 06-20-2012 05:30 AM |