language version excel

[masterflasher]

I have a problem when programming in VBA with the language version o
excel.

Somewhere I'm asking to take 'All' (for pivot).
This works off course when the language version of excel is English.
But when someone try to use the program with a French language version
an error appears.

So did someone knows how I can find out in VBA which language versio
excel has by anybody? So I can know what word I need to use and th
error will stay away?

thanks a lot

 

[Harald Staff]

Hi

Application.International(xlCountryCode)
will tell you the language version.

Errors like that can often be avoided by using an object's index number or
key instead of its name or caption. But it's difficult to present a solution
for you without the exact poroblem.

HTH. best wishes Harald