I have this issue as well. Unless you are using calls that
are not in 2000, you are best off compiling everything for
2000 (9)as it seems to be OK going up versions.

Alternatively, there are a couple of add ins you can use,
try: http://www.mvps.org/access/modules/mdl0022.htm


-----Original Message-----
I have created an addin in XL 2002, and I am now about to
distribute it
to users, but some of the users use XL 2000. These users
have
complained that the add-in does not work because of
reference errors.
Is there any way to programmatically fix the references
when loading
(e.g., if Excel 10.0 Library is not available, try to
load Excel 9.0
Library)?

Any help would be most appreciated.
.