Desktop

Ask something
Discussion Locked

Excel Spreadsheet Macro woes.......

0 helpful
1 reply

by keithmole

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We are in the process of planning a long overdue windows upgrade to Windows xp, with Win 2000 Office as our S.O.E.
We have many Excel 97 files and we assume many of these will have macro's of one form or another.

Is there a product that can helpin the identification of these files and automate the conversion process from Excel 97 to Excel 2000?

1 reply

by dklippert

There should not be any problem with a 97/2000 conversion. the VBA is identical except for a ccouple of additions.
2000 will open and work with 97. Conversion should not be required.
If you're looking for a way to work mass conversions, this code may help:

http://tinyurl.com/i9vc

This discussion is closed to new replies.