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" <(E-Mail Removed)> wrote in message
news953CE26-18ED-408B-890E-(E-Mail Removed)...
> 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
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news953CE26-18ED-408B-890E-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> news953CE26-18ED-408B-890E-(E-Mail Removed)...
> > 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
>
>
>