Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do you save a macro to another computer?

Status
Not open for further replies.

rcrecelius

Technical User
Mar 13, 2003
108
US
I'm recording a macro for a project I'm working on. I have permission to work on this project at home so if I am able to perfect the macro, I will want to have it on my home PC as well.
What is the best method for doing this?
Excel 2002 both machines
 
Copy the worksheet to a floppy and take it home with you.

If the worksheet is too big, then look under the File menu in the VBA editor. You should find both Export and Import.

Export the module from your office machine to a floppy and then import it into a worksheet on your home machine.

If you don't have a floppy drive on both machines then e-mail the file to yourself.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top