Does anyone maintain a list of differences between various versions
of EXCEL? For example, is there a list of VBA functions in Excel
2003 that won't work on Excel 97?
At the request of a couple of users, I just took an application of
mine and made it work in Excel 97. Here are three of the things I
had to do:
1. Excel 97 does not have the ROUND() function in VBA. I replaced
ROUND() with INT(), and looked at the remainder to see whether I
needed to round up.
2. I use a button to create a COMMENT on a sheet. The COMMENT
overlaps a chart. The default in Excel 97 seems to be that the
chart covers the COMMENT. (the default in later versions seems to
be that the COMMENT covers the chart.) I had to explicitly move the
COMMENT to the front.
3. Excel 97 doesn't allow several of the PasteSpecial options. I
had to use simpler choices and then adjust.
If there is a maintained list anywhere, I'd be glad to contribute to
it.