German VBA

  • Thread starter Thread starter Fan924
  • Start date Start date
F

Fan924

Does VB code generated on a US version of excel run on a German
version of excel.? I am already aware that some function names are
different.
 
It will run if the country setting for the system is set to English(U.S.),
otherwise all the code will need to be translated to the German version.
There is no automatic translation facility in Excel.
 
It will run if the country setting for the system is set to English(U.S.),
otherwise all the code will need to be translated to the German version.
There is no automatic translation facility in Excel.
Click to expand...

Thanks. You saved me some time fooling with this.
 
Fan924 -

The simple answer is "yes." John Walkenbach's book says "In general, you
need not be concerned with the language in which you write your VBA code."
So, generally, the VBA code will execute on non-English versions of Excel.
Of course, you need to translate text used in dialog boxes, etc.

- Mike
http://www.MikeMiddleton.com
 
As far as I'm aware there is no such thing as 'German VBA'.

Sure if you are using VBA to insert functions on a worksheet then
you'll probably need to translate them to the local language.

And you might need to use the seperators that that language uses.
 
Back
Top