Macro doesn't work in Excel 2003 (Con't)

[Polly]

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

 

[Thomas Ramel]

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]

 

[Jamie Collins]

Thomas Ramel wrote ...

Grüezi Polly

Polly schrieb am 11.06.2004


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]

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.