Open excel
Open your workbook
Go into the VBE
Select your project
Tools|References
Look for MISSING reference.

Uncheck that missing reference.

The missing reference may not (usually doesn't) have anything to do with the
line that caused the error.

Alan wrote:

I am getting a VBA compilation error on use of the "Trim$" string
function in Excel 2003. Specifically, I get the error message:

Compile error: Can't find project or library

and it highlights "Trim$".

Under References, "Microsoft Word 12.0 Object Library" is listed
as "MISSING". However, I do not think this is related to the
problem.

I developed this using Excel 2007 on another PC, where it
appears to work fine.

Anybody know why this is a problem? Thanks, Alan

--

Dave Peterson