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. |
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 |
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 |
All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com