trouble using functions from Strings library

[David]

I wrote some VBA code with my excel sheet but when I run it on other
computers it does not work because it does not understand TRIM or MID.
If I change the code to read Strings.Trim or Strings.Mid then it runs.
What is wrong with the installation or setup on these machines that
Excel does not automatically recognize these standard VBA functions?

Thanks in advance,

David

 

[Bob Phillips]

Sounds like you have a MISSING library. Check in Tools>References in the
VBIDE and uncheck it if so.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Helmut Weber]

Yes,

Sounds like you have a MISSING library. Check in Tools>References in the
VBIDE and uncheck it if so.

reference to VBA in particular.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

 

[Dave Peterson]

I think that this could be caused by any missing reference--not just to Visual
Basic for Applications.

 

[Bob Phillips]

In fact, seeing as VBA hasn't changed since 97, it is unlikely to be
missing.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Jon Peltier]

The Strings library seems to be the canary in the coal mine, that fails when
any library isn't found.

- Jon

 

[Helmut Weber]

Hi Jon,

The Strings library seems to be the canary in the coal mine,
that fails when any library isn't found.

exactly, now I recall.

Helmut Weber

 

[David]

Sounds like you have a MISSING library. Check in Tools>References in the
VBIDE and uncheck it if so.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Thanks -- very helpful.

 

[Bob Phillips]

Does that mean that you have solved the problem?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)