How to Use My Word Macros on Another Computer

By Marcie Thomas

At some point you may find yourself working at a computer other than where your Word macros are stored. When this happens, you may wish to copy your macros from one computer to another. This can be accomplished by saving your macros to a document template file, then copying that template file to your destination computer.

Things You'll Need

  • Microsoft Word 2007
  • Portable media or network/email access (to copy files between computers)

Step 1

Make sure the “Developer” tab is enabled for Word on both computers. To do this, in each copy of Word click the Microsoft Office button, then “Word Options,” and “Popular”. Check the box labeled “Show Developer Tab in the Ribbon.” Click “OK.”

Step 2

Create a new template on the original computer. To do this, click the Microsoft \"Office\" button, “New,” “Blank Document” and “Create.” Click the \"Office\" button again, then click “Save As.” For Windows Vista users, click “Favorite Links,” then “Templates.” For Windows XP users, in the “Save In” field, click “Trusted Templates.” In the “Save As Type” field, select “Word Macro-Enabled Template.” Give the template a name, then click “Save.”

Step 3

Copy your macros on the original computer to your newly created template. Click the “Developer” tab, then the “Document Template” button. At the bottom of the “Templates and Add-ins” window, click the “Organizer” button. In the “Organizer” window, click on the “Macro Project Items” tab. One side should already be showing the Normal.dotm template file, which is the default location for macros. On the other side of the window, drop down the list box labeled “Macro Project Items available in” and select your newly created template file. Then from the Normal.dotm side, select the macro object you wish to copy, and click “Copy.”

Step 4

Copy the new template file to the destination computer.

Step 5

On the destination computer, use “Organizer” to copy your macros from the copied template file to the default template file. Repeat Step 3 except this time copy your macros from the copied template file to the default template file (Normal.dotm).

Tips & Warnings

  • In Windows Vista, by default the user-created templates are saved in the following folder: C:\\Users\\username\\AppData\\Roaming\\Microsoft\\Templates. In Windows XP, they are saved in this folder: C:\\Documents and Settings\\username\\Application Data\\Microsoft\\Templates.
  • If you have saved your macros to a location other than the default Normal.dotm file, you will need to open that template or document to access your macros.
  • If you have saved your template to a location other than the default folder, in the Organizer window click “Close File,” then “Open File” to open a browse window.
  • This process copies macro modules, or groups of macros. To copy a single macro, you need to copy and paste your macro code via the Visual Basic editor or simply recreate the macro on the destination computer.