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 fi le with a new name, send that fi le to the co-worker,
and drag modules from your workbook to your co-worker’s workbook in the
VBA editor.
Solution: Follow these steps to save your Personal.xls fi 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.
Close Excel.
Navigate to the folder from step 5. E-mail MyPersonal.xls to your co-
worker.
1.
2.
3.
4.
5.
6.
7.
Figure 136. You choose Personal.xls in the
Project Explorer.
 
 
Search JabSto ::




Custom Search