Compile Error: Can't find project or library

J

J.B.

I'm troubleshooting a problem with Microsoft Excel VBA. The error is:
Compile Error can't find project or library.
It occurs in the VBA method CommandButton_ok_Click.
They are using version 2002 of Excel. This same error does not happen with
a different version of the script nor does it happen on Excel Version 2003.

I've checked the VBE's Tools->references option and the references menuItem
is
greyed out. What do I do now?

Thank you for your help in advance.
 
J

Jim Thomlinson

Ensure that you have selected the correct project in the VBE when you select
Tools -> References
As a guess it will be MS ActiveX Data Objects ...2.8
 
J

J.B.

Thank you.

There was a Calendar Control Object that was missing. Somehow if she
brought up the form itself it worked. (I was troubleshooting this over the
phone.)

Thank you again,

John Byrne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Compile Error can't find project or library 1
Excel 2003 with VBA - "Can't find project or library" 6
Object libray invalid problem 0
Compile Error: with VBA call to "Format" 9
SOLVER COMPILE ERROR: "CAN'T FIND PROJECT OR LIBRARY" 2003 VS 2007 1
object library problem 1
Compile Error: Can't Find Project or Library 2

Top