How to Move Excel Macros to Another PC

Excel macros can make life easier. But imagine how nice it would be to take your macros with you when you go to use another computer. This isn’t a difficult process, especially with a little forethought. There are multiple ways to take your macros with you no matter what computer you use.

Copying the Workbook

Step

Determine where your macros are saved. You can save the macros you create in the workbook you are currently using or in your personal workbook. If you want to use your macros across different workbooks, you are most likely saving them to the personal.xls workbook.

Step

Copy the workbook where the macros are saved to your chosen storage medium.

Step

Copy the workbook to the new computer and start using your macros.

Using the VBA Editor

Step

Copy the actual macros themselves from the Visual Basic editor.

Step

Go to Tools–Macro–Visual Basic Editor.

Step

Go to the Modules folder in the Project window in the left-hand corner of the screen.

Step

Open Module 1 and copy the code for the macros you wish to copy. Paste this into the notepad and copy to your chosen storage medium.

Step

Repeat Step 2 on another computer and go to Tools–Macros.

Step

Name your macro and paste the code from the notepad into the macro window. Press Create and close out of the Visual Basic Editor.