Thanks for Simon's suggestion.However, I donno "Mid
()", "Right()" or "Trim()" belong to which group. So, I
donno which one to uncheck!

Grüezi Polly

Polly schrieb am 11.06.2004

Thanks for Simon's suggestion.However, I donno "Mid
()", "Right()" or "Trim()" belong to which group. So, I
donno which one to uncheck!

Try to specify the reference exactly:

VBA.Mid(()
VBA.Right()
....
...
..

--
Regards

Thomas Ramel
- MVP for Microsoft-Excel -

[Win XP Pro SP-1 / xl2000 SP-3]

Thomas Ramel wrote ...

Grüezi Polly

Polly schrieb am 11.06.2004

Thanks for Simon's suggestion.However, I donno "Mid
()", "Right()" or "Trim()" belong to which group. So, I
donno which one to uncheck!

Try to specify the reference exactly:

VBA.Mid(()
VBA.Right()
...
..
.

It is not the VBA functions Mid, Right, trim etc *causing* the
problem. Rather, they are symptomatic of another problem i.e. an
unrelated missing reference.

For example, in a recent Excel project which had a reference to the
SOAP Toolkit, some users without the toolkit installed were getting
compile errors. The error highlight VBA's Mid function but the
underlying problem was the missing SOAP reference.

Jamie.

--

Just to add to Jamie's reply:

Inside the VBE, select your project.
Then tools|references
scroll through that list looking for MISSING

Once you find it, you'll have to decide on if you can just uncheck it or if you
have to find the replacement.



Jamie Collins wrote:

Thomas Ramel wrote ...

Grüezi Polly

Polly schrieb am 11.06.2004

Thanks for Simon's suggestion.However, I donno "Mid
()", "Right()" or "Trim()" belong to which group. So, I
donno which one to uncheck!

Try to specify the reference exactly:

VBA.Mid(()
VBA.Right()
...
..
.

It is not the VBA functions Mid, Right, trim etc *causing* the
problem. Rather, they are symptomatic of another problem i.e. an
unrelated missing reference.

For example, in a recent Excel project which had a reference to the
SOAP Toolkit, some users without the toolkit installed were getting
compile errors. The error highlight VBA's Mid function but the
underlying problem was the missing SOAP reference.

Jamie.

--

--

Dave Peterson