Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic problem
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic problem
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 -----Original Message----- 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. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic problem
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic problem
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing with Visual Basic Editor Problem | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Visual Basic Help Wizard/Index problem, can't get cursor | Excel Discussion (Misc queries) | |||
Visual Basic Problem with Chr(34) | Excel Programming | |||
Visual Basic Problem with Chr(34) | Excel Programming |