Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-2019, 02:14 PM
DaveP DaveP is offline Transferring Macros, Modules, and Forms between PCs Windows 10 Transferring Macros, Modules, and Forms between PCs Office 2010
Novice
Transferring Macros, Modules, and Forms between PCs
 
Join Date: May 2019
Posts: 11
DaveP is on a distinguished road
Default 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!!!)
Reply With Quote
  #2  
Old 06-20-2019, 03:40 PM
macropod's Avatar
macropod macropod is offline Transferring Macros, Modules, and Forms between PCs Windows 7 64bit Transferring Macros, Modules, and Forms between PCs Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 06-21-2019, 11:28 AM
DaveP DaveP is offline Transferring Macros, Modules, and Forms between PCs Windows 10 Transferring Macros, Modules, and Forms between PCs Office 2010
Novice
Transferring Macros, Modules, and Forms between PCs
 
Join Date: May 2019
Posts: 11
DaveP is on a distinguished road
Default

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!
Reply With Quote
  #4  
Old 06-24-2019, 05:38 PM
eduzs eduzs is offline Transferring Macros, Modules, and Forms between PCs Windows 10 Transferring Macros, Modules, and Forms between PCs Office 2010 32bit
Expert
 
Join Date: May 2017
Posts: 260
eduzs is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transferring Macros, Modules, and Forms between PCs Combining 3 Modules into 1 Jude24Joy Word VBA 5 02-01-2017 04:20 PM
Transferring Macros, Modules, and Forms between PCs Declaring a variable that is known across modules Officer_Bierschnitt Excel Programming 5 11-18-2015 12:28 PM
Transferring Macros, Modules, and Forms between PCs Empty Modules Greg S. Excel Programming 2 07-30-2013 01:38 PM
Transferring Macros, Modules, and Forms between PCs 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft