Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Ref
To those who Excel!
I have an xlt that has been working faultlessly for many months. Alas it it starting to fail for certan users where the cause is a missing ref. This in itself ought to be straightforward except that it is looking for : Missing Microsoft RichTextbox Control 6.0 (SP3) This is curious as this control is not included in the template. In the instances where there is no problem this reference is not listed at all - I am using Excel 2000 - The failure sympton is the predictable rejection of Right, Left or Trim The template connects to a SQL server database (ODBC) and serially calls some SPs to populate tables and graphs. I realise this is light on detail but I ask in the hope that it rings bells as is. Cheers Kieran |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Ref
go to the versions that have the reference and remove it or distribute a new
version where the reference has been removed. -- Regards, Tom Ogilvy "Kieran H" wrote: To those who Excel! I have an xlt that has been working faultlessly for many months. Alas it it starting to fail for certan users where the cause is a missing ref. This in itself ought to be straightforward except that it is looking for : Missing Microsoft RichTextbox Control 6.0 (SP3) This is curious as this control is not included in the template. In the instances where there is no problem this reference is not listed at all - I am using Excel 2000 - The failure sympton is the predictable rejection of Right, Left or Trim The template connects to a SQL server database (ODBC) and serially calls some SPs to populate tables and graphs. I realise this is light on detail but I ask in the hope that it rings bells as is. Cheers Kieran |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Ref
On Feb 2, 3:58 pm, Tom Ogilvy
wrote: go to the versions that have the reference and remove it or distribute a new version where the reference has been removed. -- Regards, Tom Ogilvy "Kieran H" wrote: To those who Excel! I have an xlt that has been working faultlessly for many months. Alas it it starting to fail for certan users where the cause is a missing ref. This in itself ought to be straightforward except that it is looking for : Missing Microsoft RichTextbox Control 6.0 (SP3) This is curious as this control is not included in the template. In the instances where there is no problem this reference is not listed at all - I am using Excel 2000 - The failure sympton is the predictable rejection of Right, Left or Trim The template connects to a SQL server database (ODBC) and serially calls some SPs to populate tables and graphs. I realise this is light on detail but I ask in the hope that it rings bells as is. Cheers Kieran- Hide quoted text - - Show quoted text - Tom, My thanks, Alas the document that the template produces is distributed wider that I would have easy access to. It only contains a procedure to print all pages and a procedure to check the locale so that it can correctly determine the page size. My reason for posting is that I am baffled that a Missing Ref can exist for a control that I am not using. The only unusual item is that I reference the VBE in order to remove modules that I do not want to be distributed unecessarrily |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Ref
References are carried in workbooks. So whatever workbook originated the
document, it contained a reference to the control. You don't have to use the control for someone to create a reference to it. -- Regards, Tom Ogilvy "Kieran H" wrote: On Feb 2, 3:58 pm, Tom Ogilvy wrote: go to the versions that have the reference and remove it or distribute a new version where the reference has been removed. -- Regards, Tom Ogilvy "Kieran H" wrote: To those who Excel! I have an xlt that has been working faultlessly for many months. Alas it it starting to fail for certan users where the cause is a missing ref. This in itself ought to be straightforward except that it is looking for : Missing Microsoft RichTextbox Control 6.0 (SP3) This is curious as this control is not included in the template. In the instances where there is no problem this reference is not listed at all - I am using Excel 2000 - The failure sympton is the predictable rejection of Right, Left or Trim The template connects to a SQL server database (ODBC) and serially calls some SPs to populate tables and graphs. I realise this is light on detail but I ask in the hope that it rings bells as is. Cheers Kieran- Hide quoted text - - Show quoted text - Tom, My thanks, Alas the document that the template produces is distributed wider that I would have easy access to. It only contains a procedure to print all pages and a procedure to check the locale so that it can correctly determine the page size. My reason for posting is that I am baffled that a Missing Ref can exist for a control that I am not using. The only unusual item is that I reference the VBE in order to remove modules that I do not want to be distributed unecessarrily |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What am I missing? | Excel Discussion (Misc queries) | |||
i'm missing something | Excel Worksheet Functions | |||
Toolbars Missing, And option to Add Missing | Excel Discussion (Misc queries) | |||
On Error? Creates 1 missing worksheet then never detects any other missing worksheets | Excel Programming | |||
I Know I'm Missing Something...but what? | Excel Programming |