Hi.

In the formulabar when I select that range I see the formula like
"=SUM(A3:A5)", what is not correct in my language.

But the when selecting the cell that I create using VBA in the formulabar I
see "=SOMA(A3:A5)", what is correct in my language.

If I hit "F2" and "Enter" everything looks the same, the error stills in the
cell.

If I force a recalculation everything looks the same, the error stills in
the cell.

I also try implement the code that changes all the = signs to = signs and
give excel another chance to reevaluated all the formulas and everything
looks the same, the error stills in the cell.

Any other options?

Thanks.

Best regards,
Sérgio Martins



"Dave Peterson" wrote:

And what do you see in the formulabar when you select that range?

Does the formula look correct in your language?

If you select the cell, hit F2, then enter (and nothing more), what happens?

If you force a recalculation (F9 or one of its variants), does the formula get
evaluated correctly?

========
If I recall correctly, there have been other posts that describe this kind of
problem -- and not all are related to language differences!

I'm not sure that I've ever seen a reason why it happens, but one suggestion
I've seen is to add a little bit to your code.

After you populate the worksheet with all your formulas:

objWs.cells.replace what:="=", Replacement:="=", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

This changes all the = signs to = signs and give excel another chance to
reevaluated all the formulas.



Sérgio Martins wrote:

Hi.
Those cells are not the problem tey only have the values 1, 2 and 3.

The content of the cell layout is like

#Name?

and the tooltip is something like

The formula have not recognized text

My error is in Portuguese that's why I say "something like".

Thanks.

Best regards,
Sérgio Martins

"Dave Peterson" wrote:

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


--

Dave Peterson