Convert XL2K wkbk w/ macros to XL97?

E

Ed

I've got a customer who still has XL97. As such, he can't open my workbook,
created in XL2000 and stuffed full of macros for searching, etc. I pasted
the front page data only into a new workbook and saved as XL97/2000, and he
opened it fine. But there were no macros in it, either. Is there an easy
way to convert this so he has full functionality?

Ed
 
M

macropod

Hi Ed,

For the most part, Excel 97 and 2000 are compatible with each other but, if
you construct a workbook using features that weren't available in Excel 97,
they won't work properly. Except for things that are macro-related, the
workbook should still open, though.

If you're using an Excel 2000 Auto_open macro, or macros fired by
calculation or activation events on the opening worksheet, they could stop
the workbook in its tracks if the macro uses code not supported in Excel 97.

Cheers
 

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

User can't see Input boxes 3
Xfer of XL95 custom menus into XL97 2
Why does excel sometimes not ask to enable macros (medium security 1
Remove/disable event macros in SavedAs wkbk? 7
Unable to assign macros to a new button in the current worksheet 1
How to protect recorded macro(s) from being edited by other???? 4
DisplayAlerts = False fails 1
2003->2007 xlsm->2003 loses worksheet commandbutton functionality 1

Top