Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to translate Excel formula function name to another language?
I am developing an Excel application in VS2005 for a multi-language
environment. The application writes a formula to an Excel cell from VB code compiled as a dll, such as MyCell.Formula = €œ=POWER(A1,B2)€ It works for English but when I select Spanish from the Windows Regional and Language Options it will show #NAME? error in MyCell. I notice if I enter the formula directly into Excel, save and reopen the workbook after selecting Spanish, then POWER will be automatically translated to POTENCIA. How to use this automatic translation capability of Excel in VB code? My code obviously does not work because it uses absolute text string. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to translate Excel formula function name to another language?
I found the answer myself. As there is no follow up to this question, I post
it here in case it may help others. The answer is to use Excel internal translation function. I inserted a formula to an Excel workbook under English settings and saved it. When it was opened in another language settings (after changing language from Regional Options or running in another computer), the formula spelling was changed automatically. Then I could filter the function name text string and use it to generate another formula in VB. This is inspired by relevant discussions on the Internet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to translate text in a whole spreadsheet one language to anoth | Excel Discussion (Misc queries) | |||
language support in excel sheet using a third party language tool | Excel Worksheet Functions | |||
How to translate excel function names from english to local langua | Excel Worksheet Functions | |||
Can You Translate This Function Into Excel Format? | Excel Worksheet Functions | |||
translate language using VBA? | Excel Programming |