View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jmR jmR is offline
external usenet poster
 
Posts: 2
Default Excel programming of formulas and globalization problem

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.