I (and one other developer) have posted problems in the
microsoft.public.office.developer.automation newsgroup about automation of
the Swedish version of Excel. (See, "Help w/ Swedish RPC error" - Jun 14,
2005, and, "international excel issues", June 17, 2005 in
microsoft.public.office.developer.automation). In my particular case, my
automation code was
built on the English version of Excel. I'm creating a calculated field for
use in a pivot table that includes the "if" statement (ie "IF( A, B, C)").
My code is failing on Swedish versions of Excel. If I change my code to
use, "OM( A; B; C)", then it works fine in the Swedish version of Excel.

I notice that this problem only occurs during automation. If a spreadsheet
is created using the English Excel, using "IF", I can save the spreadsheet.
Then, I can open it in the Swedish version of Excel, and my calculated
fields are automatically translated to use, "OM". As soon as I try to add
"IF" in a Swedish version of Excel via automation, I have problems. I have
seen this problem on Excel 2000, 2002 (XP), and 2003.

I some articles about setting LCID to the Swedish code, but I don't see how
that will help me here. In my testing of the Swedish Excel, it's a Swedish
version of Excel running on a Swedish version of XP, so LCID should already
have the Swedish setting. Am I missing something?

Thanks.