CHR() function not working in Excel 2003

[Richard Jonas]

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

 

[Dave O]

Just a guess: from an Excel tab, click >Tools >Add-Ins and make sure
"Analysis Toolpak- VBA" is checked. Then compile your code again.
Hope that does it for you!

 

[Jim Cone]

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

 

[Dave Peterson]

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]

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.

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