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

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

Post by Michael.Ta » Fri, 12 Mar 2010 19:35:22


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
 
 
 

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

Post by Bob Philli » Fri, 12 Mar 2010 20:44:03

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.

--

HTH

Bob

 
 
 

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

Post by HK » Sat, 13 Mar 2010 00:00:07

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

http://www.yqcomputer.com/

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

Hans



"Michael.Tarnowski" < XXXX@XXXXX.COM > skrev i meddelelsen
 
 
 

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

Post by Michael.Ta » Sat, 13 Mar 2010 04:26:56


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://www.yqcomputer.com/
---
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
 
 
 

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

Post by Michael.Ta » Sat, 13 Mar 2010 04:27:33


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://www.yqcomputer.com/
---
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
 
 
 

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

Post by Bob Philli » Sat, 13 Mar 2010 04:34:37

Michael,

There are also a couple of webpages that I use,
http://www.yqcomputer.com/
http://www.yqcomputer.com/

--

HTH

Bob






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://www.yqcomputer.com/
---
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
 
 
 

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

Post by HK » Sat, 13 Mar 2010 16:21:36

Michael




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