View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sergio Martins Sergio Martins is offline
external usenet poster
 
Posts: 1
Default Language independent formulas

Hi.
I have a small program that creates by code a €śExcel€ť file.
One of the cells is fill with a sum formula.

My problem is:

The program can be executed in machines that have €śExcel€ť in Portuguese or
€śExcel€ť in English, if the code fill the cell with €śSoma()€ť when the €śExcel€ť
file is created in Portuguese €śExcel€ť the file is valid in any €śExcel€ť,
however if the file is created in English €śExcel€ť the cell have an error.

I also try to set the formula like €śSUM()€ť but in this case I got the error
if the file is created in Portuguese €śExcel€ť.

To create de formula in the cell I use the following code:
objWs.Cells(6, A).Formula = "=SOMA(A3:A5)"

Can anyone explain, how can I create a €śExcel€ť file with formulas that are
independent from the language of the €śExcel€ť in the machine that create the
file?

Thanks in advance.

Best regards
Sérgio Martins