compile error can't find project or library

jgoulart · Mar 4th, 2002, 10:01 PM

I am running Excel 2000 and I am having a wierd problem when I use mid or right string commands. Every time I have one of those 2 commands in my code I get "compile error can't find project or library" . Anybody have any clues? I'm fairly certain that I have everything correct because the code runs on another computer that I have excel 97 on.

Steve Hartman · Mar 5th, 2002, 06:52 AM

I've experienced the same problem. No one knew what the problem was but I finally stumbled upon an answer. Open the VBA editor,and click on TOOLS > REFERENCES. you will get a list of available references and some of them will have check marks in front of them and one of these will probably say MISSING. uncheck the one(s) that say missing and you should be in business.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 10:01 PM	#1
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	I am running Excel 2000 and I am having a wierd problem when I use mid or right string commands. Every time I have one of those 2 commands in my code I get "compile error can't find project or library" . Anybody have any clues? I'm fairly certain that I have everything correct because the code runs on another computer that I have excel 97 on.

Mar 5th, 2002, 06:52 AM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	I've experienced the same problem. No one knew what the problem was but I finally stumbled upon an answer. Open the VBA editor,and click on TOOLS > REFERENCES. you will get a list of available references and some of them will have check marks in front of them and one of these will probably say MISSING. uncheck the one(s) that say missing and you should be in business.