I have been developing in VBA for Access and Excel for some time now. I have a question about references and older versions of Office. I just installed Office XP on my machine and have started to do some development. If I send the database to someone with Office 2000, the reference does not downgrade to say Excel 2000. It says the reference to Excel 10.0 library is missing.
Now the other way works fine. If I develop in Access 2000 and have a reference to Excel 9.0 library, and someone with Office XP opens it, the VBA will automatically upgrade the reference to 10.0.
Is there any way to make sure the correct references are used, or do I have to install both Office 2000 and Office XP on my machine and add just use the older references so that it works on all machines? Thanks.