Microsoft Office Tutorials and References
In Depth Information
COPY THE PERSONAL MACRO WORKBOOK TO ANOTHER COMPUTER
COPY THE PERSONAL MACRO
WORKBOOK TO ANOTHER COMPUTER
Challenge: You have a bunch of cool macros in your Personal Macro Workbook.
You would like to get them in a co-worker’s Personal Macro Workbook.
Setup: This process is not as daunting as it may seem. Basically, you need to
save your Personal.xls ﬁ le with a new name, send that ﬁ le to the co-worker,
and drag modules from your workbook to your co-worker’s workbook in the
Solution: Follow these steps to save your Personal.xls ﬁ le:
Open the VBA editor by pressing Alt+F11.
Find Personal.xls in the Project Explorer. Click on this entry once.
Click the Save icon in the toolbar to ensure that your latest changes are
saved (Figure 136).
Press Ctrl+G to display the immediate window.
In the immediate window, type ThisWorkbook.SaveAs "C:\MyPersonal.
xls" . You can use any folder you like, but make sure to save it with a name
other than Personal.xls.
Navigate to the folder from step 5. E-mail MyPersonal.xls to your co-
Figure 136. You choose Personal.xls in the