How can i move a macro from one computer to another

D

Dave Peterson

Macros live in excel workbooks.

So you can just copy that workbook with the macro to the other pc and open it
there.
 
G

Gord Dibben

Or you could export the module containing the macro as a *.BAS file, email it
to other computer then import to another workbook.

Gord Dibben Excel MVP
 
D

Dave Peterson

I'm not sure I'd trust the average excel user to know what to do with this,
though.

But if there were only one routine that needed to be shared, I'd use a variation
of Gord's suggestion.

I'd just copy that code into a new workbook's project. Then save that
workbook. Then send it off.
 
Top