Visual Basic problem

[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.

 

[Patrick Molloy]

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

 

[Woody]

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.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Mark Bigelow]

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

---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!