Richard,

"General" VBA functions are not part of Excel VBA and
may not have been installed on your 2003 machine.
(Some IT departments, do not do full installs)

Try prefacing your calls with "VBA."...
a = "text" & VBA.Chr$(34)

You may have to go back thru Control Panel/Add or Remove Programs
and install all of the VBA options.

Regards,
Jim Cone
San Francisco, USA


"Richard Jonas" wrote in message om...
I've written a VBA application in Excel 2002, which works correctly.
This should work on all recent versions of Excel, so I've been testing
it on Excel 2003. This includes the lines:

Dim a as String
a = "text" + Chr(34)

On Excel 2003, I'm getting the error "Compile error: Can't find
project or library", and the Chr function is highlighted.

If it's helpful, I've tried commenting this line out and I also get
the same error elsewhere when I use the Space() function. The rest of
the code runs successfully.

I've seen elsewhere that I should look in the "References" option
under the "Tools" menu, but the menu option appears to be greyed out
and I can't select it.

Does anyone have any ideas why this isn't working?

Thanks,

Richard Jonas