What error do you see?

Maybe it's not the formula causing the error--maybe it's one (or more) of the
values in A3:A5.

What are in those cells?

Sérgio Martins wrote:

Hi.
I found another interesting thing.
If I create the "Excel" file in a Portuguese version with the cell filled
with:

objWs.Cells(6, 1).Formula = "=SUM(A3:A5)"

When I open the file the cell have an error.

If then I go to VBA and fill another like that:

objWs.Cells(7, 1).Formula = "=SUM(A3:A5)"

And then go back to my worksheet, the new cell is correct. So I have two
cells one with error and one correct.

Then I go back to VBA and try to see the Formula of both cells and they are
the same.

Can anyone explain that?

My problem should be same property that I forget to activate when I create
the "Excel" file?

Thanks in advance.

Best regards,
Sérgio Martins

"Sergio Martins" wrote:

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

--

Dave Peterson