VB Errors

[Thomas]

Our department creates macros with VB (mostly in Excel)
and sends them to users across the country. Occasionaly,
we have users who have used these macros for months
without any problem and then all of sudden they get an
error message.

Most of these problems seem to occur with the Left and
Right commands. They work for a long period of time.
Then all of sudden there is an error. When we debug the
issue, the highlighted word is Left or Right. We have
begun using Mid instead and this doesn't seem to happen as
much.

(It also sometimes happens with "Cols". When we
substitute Range for Columns the issue doesn't seem to
happen as much also.)

Following is an example of code we have used for months
without any problem.

YR = IIf(Dorder = 2, Left(Dtext, 2), Right (Dtext,2))

All of sudden some, but not all, users have started
experiencing a "Compile Error: Wrong number of arguements
or invalid property assignment".

Has anybody experienced anything like this before? What
causes this issue? Does a different machine setup (e.g.,
version of Excel, etc.) have any affect?

Any information you can provide or if you can point us to
any reference material to resolve this would be
appreciated. Thanks for the help.

 

[Tom Ogilvy]

Usually this is because you have declared a variable using the function name
or declared a local function using a duplicate name.

 

[Bob Phillips]

This problem often occurs when a reference is lost to a library file.

The solution is to go into each of the machines where the problem occurs, in
the VBE go to the Tools>References menu, and if you find any items in the
list with 'MISSING' in them, click them to updater the link.

What is happening is that the machines have different versions of software
which manage to corrupt the links.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)