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

P

Polly

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

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!
Click to expand...

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]
 
J

Jamie Collins

Thomas Ramel wrote ...
Grüezi Polly

Polly schrieb am 11.06.2004


Try to specify the reference exactly:

VBA.Mid(()
VBA.Right()
...
..
.
Click to expand...

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.

--
 
D

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.
 
Top