Transferring Excel Macros From One Computer to Another
Windows
- On your old computer, open File Explorer on your old computer by pressing the Windows button and the letter E on your keyboard.
- 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

- 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.
- On your new computer, download the PERSONAL.XLSB file from your email or wherever you have it stored.
- 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.