How to Move Excel Macros to Another PC

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

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.

Advertisement

Copying the Workbook

Video of the Day

Step 1

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.

Advertisement

Video of the Day

Step 2

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

Step 3

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

Using the VBA Editor

Step 1

Copy the actual macros themselves from the Visual Basic editor.

Advertisement

Step 2

Go to Tools–Macro–Visual Basic Editor.

Step 3

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

Advertisement

Step 4

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.

Advertisement

Step 5

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

Step 6

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

Advertisement

Advertisement