Re: Compile Error: Can't Find Project or Library

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The most common cause of this is a missing reference. A missing reference can cause elements defined in other (not missing) libraries to raise these errors. In VBA, go to the Tools menu and choose References. There, see if anything in the list is marked as MISSING. If you don't need that reference, simply uncheck it from the list. If, however, you do need that library and you know where it came from, close Excel and re-install the program that created the reference in question. If you don't know where the library came from, things get tougher. You can try running "Detect And Repair" from the help menu and see if that fixes the problem. If that doesn't work, close Excel, go to the Windows Start menu, choose Run and enter

C:\Program Files\Microsoft Office\Office12\Excel.exe /regserver

and then click OK. This will cause Excel to start, re-write all of its internal settings back to "factory defaults" and quit. Now, start Excel normally and see if the problem is gone. See also http://www.cpearson.com/Excel/StartupErrors.aspx for a wide variety of things you can do to fix various Excel problems. If all these fail, you may have to uninstall and then reinstall the whole Office set of programs, but that should be done as a last resort.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"Albert Browne" <albert.browne@xxxxxxxxxxxx> wrote in message news:u$oSiDCGJHA.2112@xxxxxxxxxxxxxxxxxxxxxxx
Hi.

I have been developing a project using 2007. when I try running it under 2000 on my laptop. or on the system it is to run under I keep getting the error Compile Error: Can't Find Project or Library. The keywords that are causing problems are UCASE & DATE. There may be others but I can't get passed these at the moment. How can I solve this problem? Microsoft knowledge base points to a 404 error.

Thanks,

Albert




.

Quantcast