Dave Peterson wrote in message ...
If you're in the middle of running your code, stop it.
Then the Tools|references may be available.
Then look under that option for references that are marked MISSING.
A missing reference will cause the procedure to not compile--and might point at
any old line.
Once you find that missing reference, you'll either have to deselect it or find
what it is and correct it.
Richard Jonas wrote:
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
Thanks Dave,
I think I must not have stopped the program running when I looked
before, and when I tried today, Tools / References was available. I
found that a calendar control was labelled as missing.
My spreadsheet doesn't use a calendar control, but when I unchecked it
the Chr functions appear to work.
Kind Regards
Richard
|