how can i copy a macro to another pc

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

hi
i am trying to copy a complicated macro to another pc ( primarily for safe keeping)

any ideas?

Tom
 
Tom,

All macros are stored in workbooks, so you can simply copy the workbook file
to the other PC. Alternatively, you can export the module containing the
macro to a text file (with a "bas" file extension) and copy that file to the
other PC.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Export the macro to a .Bas file from the VBE. Import it into the new
workbook

To do either, go to the project explorer and right click on the module name
or the Modules entry.
 
i am trying to copy a complicated macro to another pc

Use the menu File | Export File to create a *.bas file.

HTH,
Merjet
 
Back
Top