Transferring Excel Macros From One Computer to Another

For Windows Based Computers

1. On your old computer, open File Explorer on your old computer by pressing the Windows button and the letter E on your keyboard.
2. Paste the following path into the address bar.  Be sure to remove [NetID] and type your NetID between the slashes.
   C:\Users\[NetID]\AppData\Roaming\Microsoft\Excel\XLStart 
   
3. If you have global macros, a file will be created called PERSONAL.XLSB.  Move the PERSONAL.XLSB file to your new computer. You can do this by sending an email to yourself with the file attached.
4. On your new computer, download the PERSONAL.XLSB file from your email or where ever you have it stored.
5. Follow steps 1 and 2 to open the correct path on your new computer and drag the PERSONAL.XLSB file into the XLStart folder.

To test if this was done correctly, open Excel on your new computer, click View > Macros > View Macros.

Notes

• If you do not see the PERSONAL.XLSB file in the path provided, try switching out Roaming with Local C:\Users\[NetID]\AppData\Local\Microsoft\Excel\XLStart 
• If you have macros embedded in a specific document and would like to make them available for use in other Excel files you can download them one by one using the VBEditor in Excel.
  • Microsoft instructions for copying macros to a Personal Macro Workbook
  • How to move Excel macros to a different computer

On Mac Based Computers

1. Open Finder > Go > Go To Folder
2. Type ~/Library and click Go
3. Open each folder:  ⁨Group Containers⁩ ▸ ⁨UBF8T346G9.Office⁩ ▸ ⁨User Content⁩ ▸ ⁨Startup⁩ ▸ Excel
4. Move the PERSONAL.XLSB file to your new computer. You can do this by sending an email to yourself with the file attached.
5. On your new computer, download the PERSONAL.XLSB file from your email or where ever you have it stored.
6. Follow steps 1-3 to open the correct path on your new computer and drag the PERSONAL.XLSB file into the Excel folder.  *If you do not have the Excel folder, you should create a Macro in Excel as a place holder so that one is created for you.

Notes:  

• Microsoft instructions for creating and saving all macros in a single workbook (macOS)