How can i create a macro in excel 2003 that will work in Excel 20.

[Guest]

I have an Excel 2003 spreadsheet which i have been creating to automate some
processes for some users. It has come to my attention that most of these
users are running Excel 2002 and after testing the Microsoft Excel 11.0
Object library is not present on the 2002 version of Excel. I need to ensure
that the Microsoft Excel 10.0 Object library is being used. I need to change
the reference libraries within excel in order to do this. If there is any way
that this can be done quickly. I am only aware so far that i will need both
versions of Excel on my machine to change which reference library to use.

If you need any additional information please let me know.
(e-mail address removed).

Thank you.

 

[Guest]

Hi
maybe use late binding. See:
http://www.xldynamic.com/source/xld.EarlyLate.html

 

[Tom Ogilvy]

Each excel version uses its own version of the libraries. If you open a
file with xl10 references in xl11, they will be changed to xl11 references I
believe. You should write your code in the lowest version of excel that
will run the code.