I have created several macro in MS Excel to help eliminate that work that is redundent. The problem is that I have two locations that I work from but would like to combine macros into a single personal file. Is there a way to copy information stored in one personal file into another? If there is how is it done?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Micro in Excel
- Thread starter bobg3
- Start date
SkipVought
Programmer
Hi,
You can do this several ways...
1. In the VB Editor (alt+F11) give the module that your macro is in a unique name other than the generic name lik Module1.
2. right click the module and export it.
3. in your other workbook, in the VB Editor, Import THAT module
OR
you could copy the code that you would like to transfer and paste it into a module in your other wotkbook.
Skip,
Skip@TheOfficeExperts.com
You can do this several ways...
1. In the VB Editor (alt+F11) give the module that your macro is in a unique name other than the generic name lik Module1.
2. right click the module and export it.
3. in your other workbook, in the VB Editor, Import THAT module
OR
you could copy the code that you would like to transfer and paste it into a module in your other wotkbook.
Skip,
Skip@TheOfficeExperts.com
- Status