how can i move a macro that runs under excel 97 to a diff pc running excel 97? regards, antz
A Antz Apr 5, 2004 #1 how can i move a macro that runs under excel 97 to a diff pc running excel 97? regards, antz
F Frank Kabel Apr 5, 2004 #2 Hi one way: - open the VBA editor - select the module and export the contents of this module (right-click on the module name) - Import this file on your other machine
Hi one way: - open the VBA editor - select the module and export the contents of this module (right-click on the module name) - Import this file on your other machine
D Dave Peterson Apr 6, 2004 #3 You could copy the workbook that contains the macro to the other pc. Remember that each open workbook has to have a unique name--you can't have two personal.xls workbooks open at the same time.
You could copy the workbook that contains the macro to the other pc. Remember that each open workbook has to have a unique name--you can't have two personal.xls workbooks open at the same time.
