trouble using functions from Strings library
 

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

trouble using functions from Strings library
 

Sounds like you have a MISSING library. Check in ToolsReferences 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)

"David" wrote in message
ups.com...
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

trouble using functions from Strings library
 

Yes,

Sounds like you have a MISSING library. Check in ToolsReferences 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"

trouble using functions from Strings library
 

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



Helmut Weber wrote:

Yes,

Sounds like you have a MISSING library. Check in ToolsReferences 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

trouble using functions from Strings library
 

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)

"Dave Peterson" wrote in message
...
I think that this could be caused by any missing reference--not just to
Visual
Basic for Applications.



Helmut Weber wrote:

Yes,

Sounds like you have a MISSING library. Check in ToolsReferences 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

trouble using functions from Strings library
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Dave Peterson" wrote in message
...
I think that this could be caused by any missing reference--not just to
Visual
Basic for Applications.



Helmut Weber wrote:

Yes,

Sounds like you have a MISSING library. Check in ToolsReferences 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

trouble using functions from Strings library
 

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

trouble using functions from Strings library
 

On Jun 4, 3:56 pm, "Bob Phillips" wrote:
Sounds like you have a MISSING library. Check in ToolsReferences 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)

"David" wrote in message

ups.com...

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 readStrings.Trim orStrings.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


Thanks -- very helpful.

trouble using functions from Strings library
 

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)

"David" wrote in message
ups.com...
On Jun 4, 3:56 pm, "Bob Phillips" wrote:
Sounds like you have a MISSING library. Check in ToolsReferences 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)

"David" wrote in message

ups.com...

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 readStrings.Trim orStrings.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


Thanks -- very helpful.