Visual Basic problem

  • Thread starter Thread starter Carol Lutz
  • Start date Start date
C

Carol Lutz

when asking to set a variable example:
sit = ActiveSheet.name

We get a compile error that says:

Can't find library or project

What does this mean and how do we correct it. The project
and libary are there and available, but the variable will
not set.
 
First, at the top of the code module, have this line:

OPTION EXPLICIT

this will force you to explicitly dim variables

Next, its difficult without seeing your code but

Dim sit as String
sit = Activesheet.Name

Now often, when I see that error message its a bit of a
red herring in that a key word is often highlighted that
has no relevence to the issue....which may be that a
reference is missing. in teh IDE, select Tools/References
& check if any are flagged as Missing. If they are, then
you'll need to browse & re-select them.

Patrick Molloy
Microsoft Excel MVP
 
make sure you have referenced the appropriate object model in your
project references.

for excel on windows 2000 micorsoft excel 9.0 object library

Woody
I am not responsible for anything you may see with my name attached to
it, i think.
 
If I'm not mistaking, when you click Tools > References in the VBE,
there is a checkbox that says MISSING next to it, which is checked. If
this is the case, uncheck that box and you should be fine.

Mark
 
Back
Top