Excel Language bug formulas

[Stef C]

Here is my problem:
I am trying to write a formula in a workbook using VB.
Unfortunatly, my users are from 5 different country, so I
can't just write "=SUM($A$1:$R$1)", in other language the
sum formulas simply do not exist...

Ex:The "SUM" function is "Somme" in french

I do not want to make selection depending on which
langage the user have on Excel... there must be a way to
call those formulas with a Tag, an ID or something...

Anybody got an idea???

Many thank!

 

[Haldun Alay]

Hi,

How do you write the formula to the cell. Which property are you using, Formula or FormulaLocal?

If you use formulalocal property, you get some errors in cell.

There are four properties, called;

Formula, FormulaLocal, FormulaR1C1, FormulaLocalR1C1.

I suggest you, to use Formula or FormulaR1C1 with VB. When you write some formulas to cell by using these properties, Excel automaticaly fills other three with local equvalents.

For Example

if you excecute following code in a French Version of Excel, You will see on Cell A2 "=SOMME($A$1:$R$1)"

Sub Test()
ActiveSheet.Range("A2").select
ActiveCell.Formula="=SUM($A$1:$R$1)"
End Sub
--
Regards

Haldun Alay

To e-mail me, please remove AT and DOT from my e-mail address.



"Stef C" <[email protected]>, iletide sunu yazdi Here is my problem:
I am trying to write a formula in a workbook using VB.
Unfortunatly, my users are from 5 different country, so I
can't just write "=SUM($A$1:$R$1)", in other language the
sum formulas simply do not exist...

Ex:The "SUM" function is "Somme" in french

I do not want to make selection depending on which
langage the user have on Excel... there must be a way to
call those formulas with a Tag, an ID or something...

Anybody got an idea???

Many thank!

 

[Guest]

Hi I have hunce that you are setting the Cell.Value = "=SUM
($A$1:$R$1)" but you really want to be setting the
Cell.Formula="=SUM($A$1:$R$1)" your users in France and
any where else in the world would see there respective
locale function. The reason is that if you create a
summation via the menu and then save the file, close Excel
and change your regional settings and then reopen the file
you'll see the formula has changed its name, try English
to French to see Sum change to Somme or to German Summe.

Hope this help
regards
KM