Cells wont calculate in French version

  • Thread starter Thread starter Electro
  • Start date Start date
E

Electro

I use the french version of Excel 2007. I created a macro that write
functions in some of the worksheet cells. However, even if teh text in the
cells is correct and that the equal sign is there, it wont calculate. I have
to manually double click on a cell to get the value of the formula. I wasn't
able to do this doubleclick by using VBA cod (and I tried a lot of things). I
finally found that the macro had to write the english name of a function in a
cell, and that excel translate it in french in the worksheet. If you write a
french function in a cell via a macro, it won't work, even if the same exact
thing is written in the cell.

This problem made me lose a lot of time and should be corrected by
Microsoft, especially because it is not mentioned anywhere, and because the
help does not provide the english names of the functions.

So my problem is already solve, but I hope I will help other.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...b62ee09&dg=microsoft.public.excel.programming
 
Just a thought Electro, the default language for vba is US-English,
irrespective of the locale.

Does your code contain Range("XX").Formula/ or Range("XX").FormulaR1C1
Try changing this to Range("XX").FormulaLocal/ or
Range("XX").FormulaR1C1Local with your French
language formula.

I think it will then work. I remember having a similar problem when working
in Germany.

Paul
 
Electr,

I experienced a similar problem this week with Excel 2003.

It was very useful to know someone else had hit the same problem..

Thanks
 
Back
Top