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

.