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
.