Thread: Macro Storage
View Single Post
 
Old 01-22-2014, 02:03 PM
NeilSC NeilSC is offline Windows 7 64bit 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