how can i copy a macro to another pc

[tom]

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

any ideas?

Tom

 

[Chip Pearson]

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)

 

[Tom Ogilvy]

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.

 

[merjet]

i am trying to copy a complicated macro to another pc

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

HTH,
Merjet