Excel 2002 reference won't register in Excel 2000

Joined
Feb 8, 2002
Messages
3,381
Office Version
  1. 365
Platform
  1. Windows
I am feeling really stupid this morning.

VBA on my Excel 2002 machine lets me add a reference to "Microsoft ADO Ext 2.7 for DDL & Security" along with several other references. For example, there is a reference to Microsoft Office 10.0 Object library.

When I take this workbook to my Excel 2000 machine, most of the references update just fine - Excel is smart enough to substitute th Microsoft Office 9.0 Object library, etc.,

Except it says that Microsoft ADO Ext 2.7 is missing.

If I start a new workbook on the Excel 2000 machine, I can add a reference to Microsoft ADO Ext 2.5 without a problem. It points to a 181K file, dated June 8 2000 called MSADOX.DLL.

I think this is the problem: On the Excel 2002 machine, ADOX 2.7 also points to MSADOX.DLL, but it is a 176K file from 8/18/2001.

Is the fact that the old and new version of this reference point to the same DLL causing the problem?

Also, while the Excel 2000 reports as ADOX 2.7 as missing, it no longer has ADOX 2.5 in the list of available references.

Am I going crazy?
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,213,544
Messages
6,114,239
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top