Transferring Excel Macros From One Computer to Another

Audience: Faculty, Postdocs, Researchers and Staff

This KB Article References: Microsoft Office 365
This Information is Intended for: Faculty, Postdocs, Researchers, Staff
Last Updated: February 21, 2020

Macros used in Excel can be saved within the document or globally to be re-used in other Excel documents. 

This article describes how to transfer global macros to other computers.  This is helpful for when you receive a new computer but find that your Excel files do not have the macros you've been faithfully using.  When created, global macros are saved in Personal Macro Workbook:

Windows

  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: 


 

Mac

  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:  https://support.office.com/en-us/article/create-and-save-all-your-macros-in-a-single-workbook-66c97ab3-11c2-44db-b021-ae005a9bc790#OfficeVersion=macOS

Additional Information


There are no additional resources available for this article.

Getting Help


The Division of Information Technology provides support on all of our services. If you require assistance please submit a support ticket through the IT Service Management system.

Submit A Ticket

Supported By


Customer Engagement and Support