How to transfer Macro to other computer?

A

Adrian

Hi,

I saved a Macro in PERSONAL.XLS, how can I transfer this Macro to other
computer?

Adrian
 
B

Bernard Liengme

Open Visual Basic Editor and go to the module
Use File | Export; this makes a BAS file
Copy the file to new PC using floppy disc, USB drive, or whatever
In new PC, open VBA Editor and use File|Import
best wishes
 
A

Adrian

that's great, thanks a lot.

Bernard Liengme said:
Open Visual Basic Editor and go to the module
Use File | Export; this makes a BAS file
Copy the file to new PC using floppy disc, USB drive, or whatever
In new PC, open VBA Editor and use File|Import
best wishes
Click to expand...
 
Top