Using english and non-English Excel commands simultaneously in anon-English installation

  • Thread starter Thread starter Michael.Tarnowski
  • Start date Start date
M

Michael.Tarnowski

Hi community,
I like this forum very much - I got many valuable insights from it. In
the past I had an English Excel installation at the office available,
recently my employer moved to the German version and deinstalled the
english one.
Now, when i use a english command like =VLOOKUP(A1,'Sheet 2'!
A1:H200,8,FALSE) adopting the country settings for "," with ";" Excel
comes up with #NAME? since I used the english term, not the german one
- but sometimes the german equivalent is not at hand as fast as
needed ;-)

However if a open a english coined workbook of a US/UK colleague with
a built-in commands in English, the german Excel instllation is able
to translate.
So, is there a kind of Addin or multi-language extension available to
use english and non-english built-in commands in a non-English
installation simultaneously?

Thks for any help, have a great day
Michael
 
You could get hold of an English Language Pack and install that in your
German version (it will cost though).

Excel does the job of translating the functions. If you send me a worksheet
with German name functions, when I open it it will appear in English because
the functions are held in tokenized form, the language version does the
translation.

You can always see what the German equivalent is because VBA ALWAYS works in
English (well American actually, but we will skip over that). So you could
type this in the immediate window

Activecell.Formula = "=VLOOKUP(A1,Sheet2!A1:M200,10,False)"

and go to Excel and you will see the formul in its German glory.
 
If you have Office 2007 you can buy Office Language Pack here for $25.

http://buy.trymicrosoftoffice.com/buyus/product.aspx?r=US_USD&family=....

I bought originally a Danish Excel and later on the English language pack
and it works absolutely fine.

Hans
Click to expand...

Thank all of you for help and advices. - But I'am looking for a kind
of "built-in-able translator" ;-)
Bob gave me the important glue "held in tokenized form, the language
version does the
translation. " - I did some googling with the keywordds "translation
excel function name" and got the amazing result there is an add-on:
TranslateIT (formerly:MultiLingual Formula Translator),
http://members.chello.nl/jvolk/keepitcool/download.html
---
Translate complete formulas between 12 excel languages (English,
Dutch, German, French, Italian, Spanish, Portuguese, Danish, Swedish,
Norwegian, Finnish and Russian).
Can be very useful in multilanguage environments or when you read the
english excel newsgroups, and happen to own a localized Excel version.
Version 3.
ADDED a routine to "localize" Analysis Toolpak functions from a
"foreign" file to local language.
parsing changed to use RegEx.
 
If you have Office 2007 you can buy Office Language Pack here for $25.

http://buy.trymicrosoftoffice.com/buyus/product.aspx?r=US_USD&family=....

I bought originally a Danish Excel and later on the English language pack
and it works absolutely fine.

Hans
Click to expand...

Thank all of you for help and advices. - But I'am looking for a kind
of "built-in-able translator" ;-)
Bob gave me the important glue "held in tokenized form, the language
version does the
translation. " - I did some googling with the keywordds "translation
excel function name" and got the amazing result there is an add-on:
TranslateIT (formerly:MultiLingual Formula Translator),
http://members.chello.nl/jvolk/keepitcool/download.html
---
Translate complete formulas between 12 excel languages (English,
Dutch, German, French, Italian, Spanish, Portuguese, Danish, Swedish,
Norwegian, Finnish and Russian).
Can be very useful in multilanguage environments or when you read the
english excel newsgroups, and happen to own a localized Excel version.
Version 3.
ADDED a routine to "localize" Analysis Toolpak functions from a
"foreign" file to local language.
parsing changed to use RegEx.
 
Michael,

There are also a couple of webpages that I use,
http://dolf.trieschnigg.nl/excel/excel.html and
http://cherbe.free.fr/traduc_fonctions_xl97.html

--

HTH

Bob

If you have Office 2007 you can buy Office Language Pack here for $25.

http://buy.trymicrosoftoffice.com/buyus/product.aspx?r=US_USD&family=...

I bought originally a Danish Excel and later on the English language pack
and it works absolutely fine.

Hans
Click to expand...

Thank all of you for help and advices. - But I'am looking for a kind
of "built-in-able translator" ;-)
Bob gave me the important glue "held in tokenized form, the language
version does the
translation. " - I did some googling with the keywordds "translation
excel function name" and got the amazing result there is an add-on:
TranslateIT (formerly:MultiLingual Formula Translator),
http://members.chello.nl/jvolk/keepitcool/download.html
---
Translate complete formulas between 12 excel languages (English,
Dutch, German, French, Italian, Spanish, Portuguese, Danish, Swedish,
Norwegian, Finnish and Russian).
Can be very useful in multilanguage environments or when you read the
english excel newsgroups, and happen to own a localized Excel version.
Version 3.
ADDED a routine to "localize" Analysis Toolpak functions from a
"foreign" file to local language.
parsing changed to use RegEx.
 
Michael

Thank all of you for help and advices. - But I'am looking for a kind
of "built-in-able translator" ;-)
Bob gave me the important glue "held in tokenized form, the language
version does the
translation. " - I did some googling with the keywordds "translation
excel function name" and got the amazing result there is an add-on:
TranslateIT (formerly:MultiLingual Formula Translator),
http://members.chello.nl/jvolk/keepitcool/download.html
---
Click to expand...


You might also want to consider the following:

Copy into Excel (A1:B340) the English and German function names for example
from one of the webpages mentioned in an earlier answer. Select A1:B340 and
import as Custom lists (Import lists from rows). Now in an empty cell write
for example TRANSPOSE (without equal sign), press the small square in the
lower right of the cell and drag downwards (or to the right) and you will
see the German equivalent MTRANS. It works both ways.
I you want to delete all these more than 300 hundred custom lists again I
think you will need a macro.

Hans
 
Back
Top