Macro compatibiltiy between XL versions

[johnhildreth]

Back to what version should a macro written in XL 2003 be compatible?
Or does it depend on the code (object model, methods, properties, etc.)
that are used?

Thanks,
John

 

[Guest]

A macro written in 2003 is compatible only with 2003. While much of the code
will be backwards compatible some of it will not. To be safe always code in
the lowest version that any of your users has. All of the code will be
forward compatible (with a few very minor exceptions like pivot tables which
changed in 2002). Not to mention 2003 uses references which will not be
availabe in the lower versions.