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

W

will A

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.
 
D

dominicb

Good afternoon Will A

No conversion is necessary. They should run just fine.

HTH

DominicB
 
W

will A

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.
 
D

dominicb

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
 
Top