View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ming Zhao[_2_] Ming Zhao[_2_] is offline
external usenet poster
 
Posts: 3
Default 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.