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.
Things You'll Need
- Microsoft Excel
- USB flash drive or other storage medium
Copying the Workbook
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.
Copy the workbook where the macros are saved to your chosen storage medium.
Copy the workbook to the new computer and start using your macros.
Using the VBA Editor
Copy the actual macros themselves from the Visual Basic editor.
Go to Tools–Macro–Visual Basic Editor.
Go to the Modules folder in the Project window in the left-hand corner of the screen.
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.
Repeat Step 2 on another computer and go to Tools–Macros.
Name your macro and paste the code from the notepad into the macro window. Press Create and close out of the Visual Basic Editor.
Tips & Warnings
- Keep track of where your macros are saved.
- You can use floppy disks, CDs, external hard drives or any other storage device you want to transfer macros.
- Be careful when editing code in the Visual Basic Editor. Changing the wrong detail can cause your workbook to not work properly. Always make a copy of your workbook before editing code.