I don't know about .net, but in VBA you can use the .Formula property with
the English formula and it will be translated automatically. Or you can use
the .FormulaLocal property and use the language of the application for the
formula.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"jmR" wrote in message
...
I've created an .Net application that fill a excel sheet. For some of the
cells, my application write a formula instead of a direct value. I'm
writing
somthing like :

oSheet2.Cells(x, y).formula = "=SOMME(CALC!A" & a & ":CALC!A" & b &
")/AY" & c

All this works fine on a FRENCH environment. It doesn't work on an ENGLISH
Excel environment.

My question is : How to do something that works with both French and
English ?

Thanks in advance.