copying excel 97 Macro to different machine

  • Thread starter Thread starter Antz
  • Start date Start date
A

Antz

how can i move a macro that runs under excel 97 to a diff
pc running excel 97?

regards,

antz
 
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
 
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 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

Exel 97 ColorIndex 1
upgrade macros to 07 7
macro issues with excel 97 2
Save As 97-2003 workbook 1
Excel 2007 crashes when perform SAVE AS to Excel 97-2003 0
Excel 97 1
make macro run other macros in Exc 2007,no problems in Exc 2003 2
Excel 2007 Can't Save File with VB Script but it can in 97/2003format??? 2

Back
Top