MISSING: XLODBC.xla

[GerardMcL]

Hi,

First of all apologies if this is wrong VB forum.
Have a program that runs in Excel and I get an error when it tries to run SQLOpen() function

Cant find project or library

So I checked and found that XLODBC.xla had to be referenced so I went to references but it is checked and listed as

MISSING: XLODBC.xla

How do I fix this? Thanks for any help!

 

[GerardMcL]

I should add its EXCEL 2000

 

[rmikesmith]

You need to install the XLODBC.XLA add-in. This should already be listed in the Add-Ins dialog (Tools|Add-Ins...) and can just be checked [note: listed as "ODBC Add-In"]. If not, browse to Drive:\Program Files\Microsoft Office\Office\Library\MSquery (that's where my copy is located; XL2000).


Regards,
Mike