Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 01:00 AM.


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