How to copy 98-97 excel macros to excel 2000 (XP)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Pc was converted to Windows XP, and my excel macros are in 98-97 ver while
the new version they installed was Excel 2000. Need to have my macros copied
pls let me know is possible.
 
Good afternoon Will A

No conversion is necessary. They should run just fine.

HTH

DominicB
 
No its not running, I checked the Personal Macro file and nothing is there.
However I still have a copy of the Personal.xls file from the old Windows ver
98. Tried to copy it to XLstart directory but still wont work.
 
Hi Will A

The problem here isn't a problem with the code but a problem with th
location of the code.

If that's the case your best bet is probably to open the "old" persona
workbook and export the macro (right click on the module in the VBE an
select Export File). then open the "new" personal workbook and impor
the macro back in, and save the workbook.

HTH

Dominic
 
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

Excel How to enable engineering functions in MS Excel 2000? 3
copy from Excel 97 output put in Excel 2000, colors don't work 1
Excel Macros 2
Excel 97 workbooks copied to Excel 2000 1
2003/XP Macros in 2000 3
Excel 97 migrating macros and toolbars to new 'used' computer 1
Excel macro 1
How copy Excel macros from Excel XP (or before) to Excel 2003? 3

Back
Top