Using english and non-English Excel commands simultaneously in a non-English installation
in [Functions]
|
From: Michael.Tarnowski on 11 Mar 2010 05:35 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
From: Bob Phillips on 11 Mar 2010 06:44 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" <emte69(a)gmx.de> wrote in message news:80870abc-d2f0-4b5e-94dc-a4b708df6350(a)v20g2000yqv.googlegroups.com... > 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
From: HK on 11 Mar 2010 10:00 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=langpack&culture=en-US I bought originally a Danish Excel and later on the English language pack and it works absolutely fine. Hans "Michael.Tarnowski" <emte69(a)gmx.de> skrev i meddelelsen news:80870abc-d2f0-4b5e-94dc-a4b708df6350(a)v20g2000yqv.googlegroups.com... > 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
From: Michael.Tarnowski on 11 Mar 2010 14:26 On Mar 11, 4:00 pm, "HK" <a...(a)b.com> wrote: > 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 > > "Michael.Tarnowski" <emt...(a)gmx.de> skrev i meddelelsennews:80870abc-d2f0-4b5e-94dc-a4b708df6350(a)v20g2000yqv.googlegroups.com... > > > 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
From: Michael.Tarnowski on 11 Mar 2010 14:27
On Mar 11, 4:00 pm, "HK" <a...(a)b.com> wrote: > 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 > > "Michael.Tarnowski" <emt...(a)gmx.de> skrev i meddelelsennews:80870abc-d2f0-4b5e-94dc-a4b708df6350(a)v20g2000yqv.googlegroups.com... > > > 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 |