Can't Find Project or Library

[marksmithy69]

I have been handed an Excel spreadsheet by my new employer which runs a macro that connects to an Oracle database to run some health checks. The problem is I get a "Can't Find Project or Library" error when I try and run it. It is bombing on this statement: Dim OraSession As OraSession

Does anyone know the proper reference that I should have selected to resolve this problem? Thank you.

 

[fumei]

Have you checked the Tools > References for unchecked ones?

Gerry

 

[marksmithy69]

Yes, I've checked and none are missing.

 

[xlbo]

doubtful given your error message

Tools>References in the VBE - it'll be one of the Oracle drivers

either that or they are using a function in one of the standard add-ins that you don't have - Analysis Toolpak for example or the XLODBC.xla file - you would certainly need that add-in installed to be able to utilise anything that is querying an Oracle database...

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question