Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reasons for "Run-time error '13':Type mismatch"?
Hi everyone, I’m using an Excel tool that runs well in my computer (unfortunately have no access to the code). When my colleague runs it in his compute it gives “Run-time error '13':Type mismatch”. Apparently there is n difference in the data entered in the program. My guess is that hi computer has a different configuration (country, data type...) o operating system version, that changes the data type. Anyone knows ho to solve this problem? What to change so both computers run the tool? Thanks in advance! Paul -- BagaAzu ----------------------------------------------------------------------- BagaAzul's Profile: http://www.excelforum.com/member.php...fo&userid=3252 View this thread: http://www.excelforum.com/showthread.php?threadid=52313 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reasons for "Run-time error '13':Type mismatch"?
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, Im 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reasons for "Run-time error '13':Type mismatch"?
Thanks Tom! Actually his computer is new, so he should have the newest version o everything... Still looking for the problem... Thanks! Paul -- BagaAzu ----------------------------------------------------------------------- BagaAzul's Profile: http://www.excelforum.com/member.php...fo&userid=3252 View this thread: http://www.excelforum.com/showthread.php?threadid=52313 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Handling to mitigate "Run Time Erorr 13 Type Mismatch" | Excel Programming | |||
Run-time Error "13" - File Type Mismatch | Excel Programming | |||
Help with Run-time error: "Type Mismatch" | Excel Programming | |||
"FIND" generates "Type mismatch" error | Excel Programming | |||
Copying data to another worksheet gives "Type Mismatch" error | Excel Programming |