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, 2014 at 10:54
  • I wonder if changing the locale on the machine helps?
    – Dave
    Jan 30, 2014 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. Jan 30, 2014 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. Feb 1, 2014 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? Mar 24, 2014 at 15:40

2 Answers 2

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, 2014 at 10:28

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .