Run time error : Excel 2000 and Excel 2003 : different behavior of Macro

[Bala]

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.

 

[paul.robinson]

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

 

[Bala]

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