Version number for Object model for VBA/Excel

[Guest]

Hi All,

There is alot of documenation that accompanies MS Office as well as on MSDN
that describe the Excel/VBA object model but none of the documentation state
what versions of excel/MS Office these object model is compatible with.

Without this documentation, (and of course other than just simply testing
your code across the MS Office product line) when developing VBA application
for excel using various objects in the excel/vba object model, how do we
ensure backward compatibility so that our project/workbook will work on older
versions of excel?

Thanks

 

[Dave Peterson]

I think that the only way to know for sure is to develop it in that older
version.

(Or spend lots and lots and lots and lots of time testing in that older
version.)

 

[Jon Peltier]

Or have your client test it for a minute!

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Dave Peterson]

Taken from the old breakfast commercial...

Let Mikey test it. He'll accept anything.