Reasons for "Run-time error '13':Type mismatch"?

[BagaAzul]

Hi everyone,

I’m using an Excel tool that runs well in my computer (unfortunately I have no access to the code). When my colleague runs it in his computer it gives “Run-time error '13':Type mismatch”. Apparently there is no difference in the data entered in the program. My guess is that his computer has a different configuration (country, data type...) or operating system version, that changes the data type. Anyone knows how to solve this problem? What to change so both computers run the tool?

Thanks in advance!
Paula

[Tom Ogilvy]

Just a guess, but if your colleague is using xl97 (or perhaps earlier), it
was less forgiving in some types of comparison operations. If this is the
case, then the code won't work. Even if he or she isn't using xl97, it
could be a similar type problem (your version of excel is newer than his - so
it is more forgiving).

--
Regards,
Tom Ogilvy


"BagaAzul" wrote:

>
> Hi everyone,
>
> I’m using an Excel tool that runs well in my computer (unfortunately I
> have no access to the code). When my colleague runs it in his computer
> it gives “Run-time error '13':Type mismatch”. Apparently there is no
> difference in the data entered in the program. My guess is that his
> computer has a different configuration (country, data type...) or
> operating system version, that changes the data type. Anyone knows how
> to solve this problem? What to change so both computers run the tool?
>
> Thanks in advance!
> Paula
>
>
> --
> BagaAzul
> ------------------------------------------------------------------------
> BagaAzul's Profile: http://www.excelforum.com/member.php...o&userid=32529
> View this thread: http://www.excelforum.com/showthread...hreadid=523134
>
>

[BagaAzul]

Thanks Tom!

Actually his computer is new, so he should have the newest version of everything... Still looking for the problem...

Thanks!
Paula