Dear Anders,

I sympathize with everybody having a hard time with non-English versions of
Excel. I use a Hungarian version, and I regularly curse those who decided to
translate English function-names into National languages, because I have to
keep in mind not only the English function set but its Hungarian version as
well (it's not so easy, because most English word can have several Hungarian
synonims, and in some cases the translators chose really funny ones).

As an assistance we have in the Hungarian version a FUNCS.XLS file in the
C:\Program Files\Microsoft Office\Office11\1038 directory containing an
ENglish-Hungarian dictionary of function names. Have a look at it, perhaps
the Swedish version also has this accessory. You always have to use the
Swedish function names when writing them directly in a sheet, and their
English originals when using them in a VBA script's FormulaR1C1= statement,
at least I didn't find any other method. (If you record a macro containing
writing a Swedish function name in a cell, the resulted script will contain
the English translation of the function name.)
Regards,
Stefi



€žAnders Lindén€� ezt Ã*rta:

Creating an excel-document using automation seems to be a national dependent process
if you ask me.

If I am doing a program that puts the IF function in a cell (using Excel.Application with IDispatch),
it works to create the document using my program on a computer with an english installation of excel.

But not if the installation language is swedish.

Then I have to use OM instead of IF. People that claims that you always can use the english translation and it will
be automatically translated to swedish, did they actually test it before they claimed it?

Am I expected to have a list with all possible translations in my program and to check which version the user
runs?

Or can I set the Excel.Application object in a certain mode where it will understand english?

/Anders