I see you have solved the problem you posted about, but I thought you might like to know that VB has lots and lots of predefined constants for use in code... one of them is vbCrLf which equates to a carriage return followed by a line feed (which is what you defined your crlf variable to be), so you can eliminate your crlf defined variable and just use the built-in vbCrLf one instead. You can see a lot (I'm not sure it is all of them) of the available constants by typing in "Visual Basic Constants" (with the quote marks) in the VB Editor's help field (at the right side of the menu bar) and hitting Enter, then select the first item in the list that appears... this will bring up a help page with more links on them... the one I just told you about is under the "Miscellaneous Constants" link along with some other related constants.

--
Rick (MVP - Excel)


"Scott" wrote in message ...
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.