Can't find project or library (Mid Function)

[Guest]

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]

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.

 

[Peter T]

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

 

[Peter T]

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

 

[Guest]

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

John