Microsoft Office Forums Macro Storage

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-21-2014, 07:47 AM
mbesspiata mbesspiata is offline Macro Storage Windows 7 32bit Macro Storage Office 2007
Advanced Beginner
Macro Storage
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default Macro Storage


In what file location are macros from MS Word stored? After I create on on my machine, I want to sent it to others to use but I can't find it once I create it.

Mike
Reply With Quote
  #2  
Old 01-21-2014, 12:26 PM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Macro Storage Windows 7 64bit Macro Storage Office 2013
Expert
 
Join Date: Aug 2011
Posts: 3,185
Stefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of light
Default

Macros are stored in macro-enabled templates or documents. The default location is the Normal.dotm template (= the blank document template).

To share macros, save them to a custom template and distribute the template. See http://word.mvps.org/faqs/macrosvba/...buteMacros.htm.
__________________
Stefan Blom
Microsoft Word MVP

Last edited by Stefan Blom; 01-22-2014 at 01:36 PM. Reason: typos
Reply With Quote
  #3  
Old 01-21-2014, 12:35 PM
Charles Kenyon Charles Kenyon is offline Macro Storage Windows 7 64bit Macro Storage Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 5,878
Charles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to all
Default

Stefan gave you the base reference.

For more, see
Global Template
Moving (Sharing) Customizations in Microsoft Word
Word 2007 & Later Key Data File Locations

For general use macros, a global template is usually best.
Reply With Quote
  #4  
Old 01-22-2014, 01:27 PM
mbesspiata mbesspiata is offline Macro Storage Windows 7 32bit Macro Storage Office 2007
Advanced Beginner
Macro Storage
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default

How can I get the macro I created in word on to other people's computers. I've tried coping and pasting it to a new module on their computer but it gives a message that it can't be saved in text format and won't save. I've saved it as a word document and a text file and neither work. They work one time but won't save on their computer.

Mike
Reply With Quote
  #5  
Old 01-22-2014, 01:37 PM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Macro Storage Windows 7 64bit Macro Storage Office 2013
Expert
 
Join Date: Aug 2011
Posts: 3,185
Stefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of lightStefan Blom is a glorious beacon of light
Default

You have to save the file containing the code in a macro-enabled template and put it in the other person's Startup folder (located in the user profile in Windows).
__________________
Stefan Blom
Microsoft Word MVP
Reply With Quote
  #6  
Old 01-22-2014, 02:03 PM
NeilSC NeilSC is offline Macro Storage Windows 7 64bit Macro Storage Office 2013
Novice
 
Join Date: Dec 2013
Posts: 24
NeilSC is on a distinguished road
Default

Quote:
Originally Posted by mbesspiata View Post
How can I get the macro I created in word on to other people's computers. I've tried coping and pasting it to a new module on their computer but it gives a message that it can't be saved in text format and won't save. I've saved it as a word document and a text file and neither work. They work one time but won't save on their computer.

Mike
Another way you could do this is to use the File / Export File facility in your VBA Editor to save the module with all the macros you want the other people to have, then use the File / Import File facility in their VBA Editors to install the macros on their computers. If their VBA Editor's File / Save function fails to save the macros, they will have to use the Import File facility every time they restart Word.
Reply With Quote
  #7  
Old 01-22-2014, 07:49 PM
Charles Kenyon Charles Kenyon is offline Macro Storage Windows 7 64bit Macro Storage Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 5,878
Charles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to all
Default

Quote:
Originally Posted by mbesspiata View Post
How can I get the macro I created in word on to other people's computers. I've tried coping and pasting it to a new module on their computer but it gives a message that it can't be saved in text format and won't save. I've saved it as a word document and a text file and neither work. They work one time but won't save on their computer.

Mike
Read the links. They are the answer to your question.
Reply With Quote
  #8  
Old 01-22-2014, 07:51 PM
Charles Kenyon Charles Kenyon is offline Macro Storage Windows 7 64bit Macro Storage Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 5,878
Charles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to all
Default

Quote:
Originally Posted by NeilSC View Post
Another way you could do this is to use the File / Export File facility in your VBA Editor to save the module with all the macros you want the other people to have, then use the File / Import File facility in their VBA Editors to install the macros on their computers. If their VBA Editor's File / Save function fails to save the macros, they will have to use the Import File facility every time they restart Word.
This is really doing it the hard way. Have you tried using a global template?
Reply With Quote
  #9  
Old 01-22-2014, 10:08 PM
fumei fumei is offline Macro Storage Windows 7 64bit Macro Storage Office XP
Expert
 
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default

mbesspiata, Stephan and Charles have given you the links and information to do what you ask for. A global template file, either put into another computer's Word Startup folder (if you want the macro code available automatically), or in any available folder if you want to be able to load it (or unload it) dynamically.

Yes you can also use an export\import file, but as Charles mentions, it is doing it the hard way, and not needed. Plus it only works one at a time; if you want multiple other computers to have access over a network, then a global template is the only way to go.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom icon storage location in Word 2007 and newer Boatwrenchv8 Word VBA 0 09-20-2013 06:42 PM
custom icon, undo/redo for macro, permanent macro Rapier Excel 0 08-05-2013 06:30 AM
Outlook Storage dpslusser Outlook 1 08-23-2012 11:48 AM
email storage by job sgk18 Outlook 0 03-26-2012 06:23 PM
transfering outlook PST to a new pc, unused storage folder and suggested contacts burgers Outlook 1 06-14-2011 04:05 PM


All times are GMT -7. The time now is 07:27 PM.


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