T
TJ Dowling
I am developing an Access/Excel application for a client who uses Office
2000. I am writing the code in Access 2003 but saving as version 2000.
Whenever I send the client an mdb file for testing, they get an error since I
reference the Excel 11 object library while they have the Excel 9 object
library.
I have a copy of Office 2000 but don't want to install it on the same
machine as Office 2003. I just want the reference to the Excel 9 object
library which is found in the file named "Excel9.olb". I copied the olb
file to the folder "C:\Program Files\Microsoft Office\Office" and tried to
reference it from the VBA code window using Tools/References and then the
browse button. I can find the olb file but it never shows up in the
references dialog.
Do I need to register the olb file or is there an easier way to reference
the Excel 9 object library without installing Office 2000?
Thanks,
TJD
2000. I am writing the code in Access 2003 but saving as version 2000.
Whenever I send the client an mdb file for testing, they get an error since I
reference the Excel 11 object library while they have the Excel 9 object
library.
I have a copy of Office 2000 but don't want to install it on the same
machine as Office 2003. I just want the reference to the Excel 9 object
library which is found in the file named "Excel9.olb". I copied the olb
file to the folder "C:\Program Files\Microsoft Office\Office" and tried to
reference it from the VBA code window using Tools/References and then the
browse button. I can find the olb file but it never shows up in the
references dialog.
Do I need to register the olb file or is there an easier way to reference
the Excel 9 object library without installing Office 2000?
Thanks,
TJD