Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time error : Excel 2000 and Excel 2003 : different behavior of Macro
Hi,
Anyone has a solution for this? I have an application using Excel Macros. I have developed it with using Microsoft Excel 2000 under Windows 2003 server. It works fine in my machine and all the other machines in our organization. But when it is sent to the Client, client is getting run time error, saying Type Mismatch in one of the parts of the application and in the other part saying Method 'Range' of object '_Global' failed. Client end has Office 2003 under Windows XP Professional. Basically the Type Mismatch error is coming in a function which has the return value as String value but used to get double values also. The other error Range Selection failed is in a function where the range is selected based on some condition and deleting the particular range. Any Solutions/Suggestions? Regards, Bala. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time error : Excel 2000 and Excel 2003 : different behavior of Macro
Hi
very difficult to give solutions or suggestions without seeing the code. If your function can have 2 sorts of output, make it return a variant and see how that goes. The range problem is impossible to diagnose without code. Range selection is always a nuisance when you are switching between sheets as you read and write data. regards Paul |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time error : Excel 2000 and Excel 2003 : different behavior of Macro
Hi Paul,
I got the problem solved by changing the Regional Settings. The client was having the Regional Settings as German, whereas my development was based on US. So it was corrected after changing the regional setting. Regards, Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange 'protected cell' error affecting Excel 2003 but not Excel 2000? | Excel Discussion (Misc queries) | |||
Change in Link Behavior - Excel 2000 to 2003 | Links and Linking in Excel | |||
Excel 2000 - Excel 2003 now throws 'runtime error' | Excel Programming | |||
Macro error after switching from Excel 2000 to Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 file opend in Excel 2000 - Compile error in hidden modu | Excel Programming |