Thanks a lot, Mr. Pearson.
A couple of references were marked "Missing". I unchecked them and added
back. The program is now working.

"Chip Pearson" wrote:

If you have a reference that cannot be found, you'll often get
compiler errors on functions whose modules can be found. It seems the
compiler gets a bit confused when resolving references if any
reference is missing. In VBA, with your project open, go to the Tools
menu, choose References, and see if any reference is marked "MISSING".
If you find such a missing reference, you can (1) uncheck it and
ignore it, if your project doesn't need it, or (2) add in back if you
know the file name or the GUID of the reference, or (3) contact the
vendor for assistance in reinstalling the application responsible for
that reference.

You might try starting Excel with the /regserver switch. Close Excel,
and go to the Windows Start menu, choose Run, and enter the following,
including the quotes as shown:

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

Of course, you may have to modify the folder specification to match
your installation. The /regserver switch tells Excel to start up and
rewrite all of its registry items back to "factory defaults". Once
you do this, close Excel and start it normally. The /regserver switch
can cure all manner of problems with Excel.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



On Thu, 4 Feb 2010 11:58:01 -0800, Scott
wrote:

I have the following line working on 2003, but not 2007.

crlf = Chr$(13) & Chr$(10)

It highlights "Chr$" and says, "Compile error: can't find project or
library." Then it pops up the "References - VBAProject".

Thanks for any help.
.