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
|