D Dave Peterson Sep 8, 2004 #2 Macros live in excel workbooks. So you can just copy that workbook with the macro to the other pc and open it there.
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 Sep 8, 2004 #3 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
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 Sep 9, 2004 #4 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.
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.