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

Thank you.

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

"cg084" wrote:

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

Thank you.

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.



--
Regards,
Tom Ogilvy

"cg084" wrote in message
...
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.
.

Thank you.