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?

5
  • can't you edit the excel macro and (looking at your example) replace =somme with =sum – barlop Jan 30 '14 at 10:54
  • I wonder if changing the locale on the machine helps? – Dave Jan 30 '14 at 12:46
  • 3
    What 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 Jan 30 '14 at 14:04
  • 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 Feb 1 '14 at 11:40
  • 2
    Can you include the text of the macro, as that would allow folks to suggest modifications that would make it work? – Jason Aller Mar 24 '14 at 15:40
4

You have two options that involve rewriting your VBA code.

  • First option: whenever accessing the Range.Formula property, replace it for the Range.FormulaLocal property. The localized version of the formulas will be translated by Excel into the English version it uses internally. This will of course make your macros only work in the French locale/language.

  • Second option: manually translate every formula hardcoded in your VBA into English. This will make your macros work in any Excel locales/languages.

1

I had a similar problem with a Excel Macro tool written in the USA and I wanted to use it with in Germany. The tool seemed to get locked in a loop after starting so it didn't come to an end.

I could finally solve this issue with changing the windows default for date, time, and number format, into US-standard like described here . So probably the VBA code of the tool works with some data in US standard formats and it won’t work in foreign format systems.

1
  • 1
    Welcome to SuperUser. Could you please add the steps you took to solve this problem? The actual answer is on the website you linked, but links can become broken or outdated, making this answer useless. – mtak Aug 25 '14 at 10:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.