Browse » Home
Saturday, April 16, 2011
How to Move Excel Macros to Another PC
Copying the Workbook
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.
2. Copy the workbook where the macros are saved to your chosen storage medium.
3. Copy the workbook to the new computer and start using your macros.
Using the VBA Editor
4. Copy the actual macros themselves from the Visual Basic editor.
5. Go to Tools–Macro–Visual Basic Editor.
6. Go to the Modules folder in the Project window in the left-hand corner of the screen.
7. 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.
8. Repeat Step 2 on another computer and go to Tools–Macros.
9. Name your macro and paste the code from the notepad into the macro window. Press Create and close out of the Visual Basic Editor.