VB backwards compatability to 97

[Dave]

Hello, I created an Excel 2000 based application which
uses a bunch of VB macros I created. I distributed this
program to someone using Excel 97 and many of macros do
not seem to work.

Can someone clarify the backwards compatability of VB from
2000 to 97?

Thank you in advance.

Dave

 

[Tom Ogilvy]

One problem is that some properties and methods available in xl2000 are not
available in xl97. Same for some of the arguments to functions shared in
both. If you use any of these, then you would get an error in xl97.

 

[Guest]

I've got a Web tool that lists Excel objects by year introduced at:

http://www.mstrainingkits.com/Excel/ExcelObjects.aspx

It's only by object at this point. I might add version info for methods/properties in the future, given time. If it helps, let me know...