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


"tom" wrote in message
om...
hi
i am trying to copy a complicated macro to another pc ( primarily for safe
keeping)

any ideas?

Tom

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.

--
Regards,
Tom Ogilvy



"tom" wrote in message
om...
hi
i am trying to copy a complicated macro to another pc ( primarily for safe
keeping)

any ideas?

Tom

i am trying to copy a complicated macro to another pc

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

HTH,
Merjet