Converting workbook to run on German excel

[Fan924]

I have a rather large workbook made on an US version of excel 97. It
requires the add-in Analysis ToolPak since I use functions HEX2DEC &
DEC2HEX.

When run by a friend in Germany, he gets #name errors everywhere. This
is the first that I am aware of this, that German excel uses different
spelling for function names. HEX2DEC is HEXINDEZ in German.

Is there an application that will convert the entire worksheet so that
it will run with German excel?

 

[Ron de Bruin]

Hi Fan924

See this page
http://www.rondebruin.nl/international.htm

 

[Ron de Bruin]

See also the Useful links section on that page on the bottom

 

[John]

Hi Fan924
You could use "Find & Replace" in the edit menu.
Play with a copy not your original, just to make sure everything is working ok.
HTH
John

 

[Fan924]

Hi Fan924
You could use "Find & Replace" in the edit menu.
Play with  a copy not your original, just to make sure everything is working ok.
HTH
John

Hi John,

Did that a few days ago. Replaced with german DEZINHEX & HEXINDEZ. It
did not work. There must be other differences that I am not aware of.
I do not have a german copy of excel so I can't test it.

 

[Fan924]

See also the Useful links section on that page on the bottom

Thanks Ron,

I found this on that page, "Analysis ToolPak Translator 7.0"
There is a "Bi-Directional Translator" in it but have not figured out
how to make it work.

 

[Fan924]

The funtion names may not be the only problem.
Is VBA code from a US excel version going to work in a German copy of
excel?