Version number for Object model for VBA/Excel
 

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

Version number for Object model for VBA/Excel
 

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.)



Bing wrote:

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

Version number for Object model for VBA/Excel
 

Taken from the old breakfast commercial...

Let Mikey test it. He'll accept anything.



Jon Peltier wrote:

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 wrote:

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.)



Bing wrote:

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