If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using english and non-English Excel commands simultaneously in anon-English installation
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 |
#2
|
|||
|
|||
Using english and non-English Excel commands simultaneously in a non-English installation
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 "Michael.Tarnowski" wrote in message ... 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 |
#3
|
|||
|
|||
Using english and non-English Excel commands simultaneously in a non-English installation
If you have Office 2007 you can buy Office Language Pack here for $25.
http://buy.trymicrosoftoffice.com/bu...&culture=en-US I bought originally a Danish Excel and later on the English language pack and it works absolutely fine. Hans "Michael.Tarnowski" skrev i meddelelsen ... 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 |
#4
|
|||
|
|||
Using english and non-English Excel commands simultaneously in anon-English installation
On Mar 11, 4:00*pm, "HK" wrote:
If you have Office 2007 you can buy Office Language Pack here for $25. http://buy.trymicrosoftoffice.com/bu...US_USD&family=.... I bought originally a Danish Excel and later on the English language pack and it works absolutely fine. Hans "Michael.Tarnowski" skrev i ... 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 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 |
#5
|
|||
|
|||
Using english and non-English Excel commands simultaneously in anon-English installation
On Mar 11, 4:00*pm, "HK" wrote:
If you have Office 2007 you can buy Office Language Pack here for $25. http://buy.trymicrosoftoffice.com/bu...US_USD&family=.... I bought originally a Danish Excel and later on the English language pack and it works absolutely fine. Hans "Michael.Tarnowski" skrev i ... 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 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 |
#6
|
|||
|
|||
Using english and non-English Excel commands simultaneously in a non-English installation
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 "Michael.Tarnowski" wrote in message ... On Mar 11, 4:00 pm, "HK" wrote: If you have Office 2007 you can buy Office Language Pack here for $25. http://buy.trymicrosoftoffice.com/bu...US_USD&family=... I bought originally a Danish Excel and later on the English language pack and it works absolutely fine. Hans "Michael.Tarnowski" skrev i ... 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 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 |
#7
|
|||
|
|||
Using english and non-English Excel commands simultaneously in a non-English installation
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 --- 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 |
Thread Tools | |
Display Modes | |
|
|