6
I am currently in France and am using a computer on which all Office programs are in French.
I need to use a Macro which has been written in English VBA, but it fails.
I assume the issue a language issue as the same thing occurs when I try using English Excel formulas in the French version (e.g. =sum is =somme)
Is there a way of doing this?
can't you edit the excel macro and (looking at your example) replace =somme with =sum – barlop – 2014-01-30T10:54:37.010
I wonder if changing the locale on the machine helps? – Dave – 2014-01-30T12:46:00.507
3What is failing? VBA should work as it's only written in English (previously, not sure about 2013). What error are you getting? It may be a regional setting that you need to modify. Worksheet functions should translate automatically, everything else should work fine. – Raystafarian – 2014-01-30T14:04:10.810
If the macro adds items to the menus etc. it can run into trouble because these ARE different from one language version of Office to another. There are ways of addressing menus by ID rather than by name in order to get around this problem. – Steve Rindsberg – 2014-02-01T11:40:09.610
2Can you include the text of the macro, as that would allow folks to suggest modifications that would make it work? – Jason Aller – 2014-03-24T15:40:20.673