Macro created in english is not working in French environment/Laptop

[guruprasadch]

Team,
My excel file with macros is working just fin in my laptop (configured for US English language) but the same file throws below error message when my colleagues in Paris with French OS try to open it.

Error Message: “Excel encountered non readable content in the file. Do you want to recover the content of this file? If it is reliable, click yes”.

I tried searching on net, found conflicting answers; some posts asked to change some formulae which are not supported in French language or to convert whole macro into French. However some other posts suggested that Excel-97 onward its language neutral.


Please help me solve this problem, and let me know if you need additional information or code snippet .


Regards,
Guruprasad C H

 

[guruprasadch]

Hello Milenia,
Thanks for the response; and there are no numbers used in names or variables.

Regards,
Guruprasad C H

 

[RoryA]

First, please use code tags when posting code (I've added them for you above).

I can't see anything obviously wrong there, although you should really use the FormulaR1C1 property when assigning an R1C1 format formula, rather than Value:

ActiveWorkbook.Sheets("TFSDump").Range(tbcolumn).FormulaR1C1 = formula

 

[guruprasadch]

Thanks for confirming the code correctness; i will have to find the right cause.

Regarding code tags, my apologies, wasn't aware how to add them..