Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Broken reference for chr function
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Broken reference for chr function
More than likely there is a broken reference.
Commonly occurs on a different PC to the developer due to some component not installed. From VBA | Tools | References, check for a reference which says Broken. Suspect it is ActiveX Data Objects 2.8 -- Rob van Gelder - http://www.vangelder.co.nz/excel "Bill Murphy" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Broken reference for chr function
Rob,
I checked my references, and none of them say broken or missing. Are there any other references that you feel I need to get the chr function? Bill "Rob van Gelder" wrote in message ... More than likely there is a broken reference. Commonly occurs on a different PC to the developer due to some component not installed. From VBA | Tools | References, check for a reference which says Broken. Suspect it is ActiveX Data Objects 2.8 -- Rob van Gelder - http://www.vangelder.co.nz/excel "Bill Murphy" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Broken reference for chr function
In my experience, VBA functions which suddenly appear invalid are caused by
References being unavailable on the target PC. Try unchecking each reference. Run again. Check the reference again. Run again. Chr is a function of the "Visual Basic for Applications" Reference. Can you describe how this problem started? Are you running it on a PC difference from your development PC? -- Rob van Gelder - http://www.vangelder.co.nz/excel "Bill Murphy" wrote in message ... Rob, I checked my references, and none of them say broken or missing. Are there any other references that you feel I need to get the chr function? Bill "Rob van Gelder" wrote in message ... More than likely there is a broken reference. Commonly occurs on a different PC to the developer due to some component not installed. From VBA | Tools | References, check for a reference which says Broken. Suspect it is ActiveX Data Objects 2.8 -- Rob van Gelder - http://www.vangelder.co.nz/excel "Bill Murphy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need reference for max and [#this row] function | Excel Worksheet Functions | |||
large function result as reference for offset function | Excel Discussion (Misc queries) | |||
I believe the rate function is broken in Excel 2003.... I can't verify this with other sources though | Excel Discussion (Misc queries) | |||
Excel graph function is broken | Charts and Charting in Excel | |||
Linest: problems using broken reference data | Excel Worksheet Functions |