I use the Microsoft Excel 10.0 object references in a database. The problem is that when someone else opens the database and runs the code if they have Excel 2000 I need to go in and add the Microsoft Excel 9.0 object library. How do I solve this issue?
References
- Thread starter jesseb
- Start date
Memnoch1207
Registered User.
- Local time
- Today, 09:47
- Joined
- May 10, 2002
- Messages
- 17
My assumption is the 10.0 library is for XP and the 9.0 is for 2000. I would think that the 10.0 would be (backward compatible) so as to allow any version of Excel to open with that object library.
[This message has been edited by Memnoch1207 (edited 05-20-2002).]
[This message has been edited by Memnoch1207 (edited 05-20-2002).]
- Local time
- Today, 03:47
- Joined
- Feb 28, 2001
- Messages
- 30,168
Probably, the libraries changed names on you.
I believe you can look up "References" in the Help files to find the AddReference and other routines that help you to control the references made in your database. You would have to look at the properties of the application object to get a version number in order to know which references you need.
I believe you can look up "References" in the Help files to find the AddReference and other routines that help you to control the references made in your database. You would have to look at the properties of the application object to get a version number in order to know which references you need.
Similar threads
