Broken reference for chr function

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bill Murphy (wmurphy_at_houston.rr.com)
Date: 06/12/04 

Date: Sat, 12 Jun 2004 02:33:22 GMT

I have all the normal references set like:

VBA
Excel 10.0 Object library
Windows common controls 6.0
VBA for applications extensibility 5.3
ActiveX data objects 2.8

When I compile my VBA code containing the chr function, which I thought was
very common, I get a "Can't find project or library" error message with chr
highlighted. Is there another reference I should set in my workbook to
prevent this?

Bill

Relevant Pages

  • Re: Writing data to SQL server
    ... I have to use Excel because I have a good deal of VBA ... >> The best way to accomplish this is with ADO - ActiveX Data Objects. ... >> the VBA editor - you will find it under Microsoft ActiveX Data Objects). ...
    (microsoft.public.excel.programming)
  • Re: Using VBA to connect Word 2003 to SQL Server 2000
    ... It looks like all you need to do is set a reference to the appropriate version of the Microsoft ActiveX Data Objects library. ... In the VBA editor, go to Tools, References, and check the appropriate library. ... the connection so I can access records and I can handle the rest. ...
    (microsoft.public.word.vba.general)
  • RE: Add Microsoft ActiveX Data Objects 2.8 Library in code
    ... you will still need to manually add the reference from VBA Tool. ... "hitmonkong" wrote: ... Is there any way that I can add Microsoft ActiveX Data Objects 2.8 Library ...
    (microsoft.public.excel.programming)