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