VBA in Excel 2003 isn't recognizing the Mid function, and UCase functions. I
have tried adding every library that looks like it would include these
functions but have not located the right one.

Does anyone know the right library to add so that these functions will work
again?

(When this was originally written, VS 6.0 was installed on the computer, now
VS.Net 2003 is on the computers.)

Thanks for any help.
John

Open your workbook, go to the VBE, select your project that is causing the
trouble.

Tools|References
Look for MISSING

A missing reference can give this kind of error. You'll have to decide if you
need to remove that reference or replace it.

John Viall wrote:

VBA in Excel 2003 isn't recognizing the Mid function, and UCase functions. I
have tried adding every library that looks like it would include these
functions but have not located the right one.

Does anyone know the right library to add so that these functions will work
again?

(When this was originally written, VS 6.0 was installed on the computer, now
VS.Net 2003 is on the computers.)

Thanks for any help.
John

--

Dave Peterson

This symptom, unable to find the VBA Strings library, is highly indicative
of a missing reference. Look under Tools References for anything marked
MISSING.

As a temporary workaround you can probably get your Mid function to work by
fully qualifying. But best to get to the route of the problem.

Regards,
Peter T


VBA.Strings.Mid(etc
"John Viall" wrote in message
...
VBA in Excel 2003 isn't recognizing the Mid function, and UCase functions.
I
have tried adding every library that looks like it would include these
functions but have not located the right one.

Does anyone know the right library to add so that these functions will
work
again?

(When this was originally written, VS 6.0 was installed on the computer,
now
VS.Net 2003 is on the computers.)

Thanks for any help.
John

That's odd, no idea how "VBA.Strings.Mid(etc" got tacked to the end of the
post. I'm sure I wrote it as the next line after "....by fully qualifying".

Peter T

"Peter T" <peter_t@discussions wrote in message
...
This symptom, unable to find the VBA Strings library, is highly indicative
of a missing reference. Look under Tools References for anything marked
MISSING.

As a temporary workaround you can probably get your Mid function to work
by
fully qualifying. But best to get to the route of the problem.

Regards,
Peter T


VBA.Strings.Mid(etc
"John Viall" wrote in message
...
VBA in Excel 2003 isn't recognizing the Mid function, and UCase
functions.
I
have tried adding every library that looks like it would include these
functions but have not located the right one.

Does anyone know the right library to add so that these functions will
work
again?

(When this was originally written, VS 6.0 was installed on the computer,
now
VS.Net 2003 is on the computers.)

Thanks for any help.
John

Thanks, I was trying to add libraries, after I removed them life was good.

John

"Peter T" wrote:

This symptom, unable to find the VBA Strings library, is highly indicative
of a missing reference. Look under Tools References for anything marked
MISSING.

As a temporary workaround you can probably get your Mid function to work by
fully qualifying. But best to get to the route of the problem.

Regards,
Peter T


VBA.Strings.Mid(etc
"John Viall" wrote in message
...
VBA in Excel 2003 isn't recognizing the Mid function, and UCase functions.
I
have tried adding every library that looks like it would include these
functions but have not located the right one.

Does anyone know the right library to add so that these functions will
work
again?

(When this was originally written, VS 6.0 was installed on the computer,
now
VS.Net 2003 is on the computers.)

Thanks for any help.
John