Converting workbook to run on German excel

F

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?
 
J

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
 
F

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.
 
F

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.
 
F

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top