Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thanks
Didn't unchecking the missing control make the problem go away?
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KaiRich wrote: Sometimes, like this, it makes no sense at all! There was a missing reference, but it was for the calendar tool (which had caused a problem before), not for the vba.strings library. Thanks anyhow. -----Original Message----- Often the line of code indicated in the crash is completely unrelated to the error (what, you expect VBA to make sense?). If you read the Google archives of these newsgroups, you will find this error very often (I know, I just checked for a client), the answer is always Check for a Missing Reference", and the OP responds with "Thanks!" My client hasn't tried the fix yet, but I expect to hear the Thanks from him tomorrow when he does. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KaiRich wrote: Hi all, I have a few PCs that are crashing on the vb function 'Left'(). When any macro uses the 'Left' function the PC crashes with "Compile Error: Can't find object or library'. I have searched the MS knowledge base, but the only articles suggest opening the references box and unchecking the offending library, but the routines for finding which is the offending library don't work in this situation (nor do I think that it is a valid solution to this problem). What dll, ocx, olb, etc. is missing or corrupted to cause vb to crash on such a basic function? Or is something else causing this and if so how do I resolve it? Thanks in advance, Kai . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thanks
Of course, the other approach, Strings.Whatever, is more robust, and
what I use when a problem arises. Checking references has to be done on all the client's machines, though it can solve a wider array of problems. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Jon Peltier wrote: Didn't unchecking the missing control make the problem go away? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KaiRich wrote: Sometimes, like this, it makes no sense at all! There was a missing reference, but it was for the calendar tool (which had caused a problem before), not for the vba.strings library. Thanks anyhow. -----Original Message----- Often the line of code indicated in the crash is completely unrelated to the error (what, you expect VBA to make sense?). If you read the Google archives of these newsgroups, you will find this error very often (I know, I just checked for a client), the answer is always Check for a Missing Reference", and the OP responds with "Thanks!" My client hasn't tried the fix yet, but I expect to hear the Thanks from him tomorrow when he does. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KaiRich wrote: Hi all, I have a few PCs that are crashing on the vb function 'Left'(). When any macro uses the 'Left' function the PC crashes with "Compile Error: Can't find object or library'. I have searched the MS knowledge base, but the only articles suggest opening the references box and unchecking the offending library, but the routines for finding which is the offending library don't work in this situation (nor do I think that it is a valid solution to this problem). What dll, ocx, olb, etc. is missing or corrupted to cause vb to crash on such a basic function? Or is something else causing this and if so how do I resolve it? Thanks in advance, Kai . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|