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

.

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


.