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