How to transfer Macro to other computer?

  • Thread starter Thread starter Adrian
  • Start date Start date
A

Adrian

Hi,

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

Adrian
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

running macros 2
Problem with Personal.XLS and macros added to my toolbar 3
Macros in Personal.xls... 3
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Excel Macro problems 1
Deleting macros? 5
Unhide command? 2
How to record a macro within a macro 9

Back
Top