Compile Error: Can't Find Project or Library

[Albert Browne]

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

 

[JLGWhiz]

In the VB editor, Tools>References and check the missing dll file. Your
error message should identify the one that is missing.

 

[Chip Pearson]

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)