Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How To Deploy Word 2010 Macros To Others?

I have a macro that I developed in Word 2010.

How do I send this to others to use?

like image 891
Ann Sanderson Avatar asked Feb 21 '12 20:02

Ann Sanderson


2 Answers

From the sublime to the ridiculous, here are four different options:

  1. Create an add-in. Distribute and tell others to install it. Instructions
  2. Create a COM add-in. Distribute and tell others to set a reference to it. Instructions
  3. Export the code module containing your macro to a *.bas file. (Right-click module, Export File...) Distribute and tell others to import it.
  4. Copy-paste macro code into an e-mail. Distribute and tell others to paste it into a module.
like image 99
Jean-François Corbett Avatar answered Oct 21 '22 17:10

Jean-François Corbett


Save the document as .dotm (macro enabled template). Save it to

%Appdata%/Microsoft/word/startup

Close word. Now, it will be accessible to all other word documents.

If not by default, then go to templates and tick the file saved above

to deploy, create a simple script that copies the file to the appropriate folder. You can probably deploy via email

like image 20
Django Doctor Avatar answered Oct 21 '22 19:10

Django Doctor