CHR() function not working in Excel 2003
 

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

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!

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

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

--

Dave Peterson

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