Transferring Microsoft Office Macros

Transferring Macros between computers

Macros are essentially pre built scripts that, when run, can format a document according to the users wishes.

In Windows 7 this process is pretty simple.

First navigate to C:\Users\owner\AppData\Roaming\Microsoft note that owner will actually be the user name of whoever owns the computer.

If you cannot see the AppData folder, then in the file explorer click Organize -> Folder and search options. From there go to the view tab and then select Show hidden files, folders, drives.

Word

Once in the Microsoft folder go to Templates and copy the Normal.dotm file to the same location on the destination computer. (C:\Users\owner\AppData\Roaming\Microsoft\Templates)

Excel

Once in the Microsoft folder go to Excel and then XLSTART from here copy the personal folder to the same location on the destination computer. (C:\Users\owner\AppData\Roaming\Microsoft\Excel\XLSTART)

To make the destination computer recognize the new macros just close all office applications and then re open them.