Difference between revisions of "Transferring Microsoft Office Macros"
m (moved Transferring macros to Transferring Microsoft Office Macros) |
m (Improved formatting) |
||
| Line 5: | Line 5: | ||
In Windows 7 this process is pretty simple. | 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. | + | First navigate to <tt>C:\Users\owner\AppData\Roaming\Microsoft</tt> 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. | + | 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=== | ===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) | + | Once in the Microsoft folder go to Templates and copy the Normal.dotm file to the same location on the destination computer. (<tt>C:\Users\owner\AppData\Roaming\Microsoft\Templates</tt>) |
===Excel=== | ===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) | + | 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. (<tt>C:\Users\owner\AppData\Roaming\Microsoft\Excel\XLSTART</tt>) |
To make the destination computer recognize the new macros just close all office applications and then re open them. | To make the destination computer recognize the new macros just close all office applications and then re open them. | ||
Revision as of 11:01, 26 January 2012
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.