Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Language independent Pivot settings | Excel Programming | |||
Insertion of formulas in foreign language in english version of ex | Excel Discussion (Misc queries) | |||
language support in excel sheet using a third party language tool | Excel Worksheet Functions | |||
How to write a language independent formula | Excel Programming | |||
Excel Language bug formulas | Excel Programming |