Where can I find the Function names in other languages

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have a function that searches on a string that makes up a function name say
"=IF(". Now lets assumed that I can do this perfectly, ignoring any string
search shortfalls of VBA (I know I can use Regular Expressions too).

If I am doing this in a version of Excel that is not English say French, the
IF Statment will likely not be the english IF. As such a search for "IF(" in
a french version - or any other version - of windows is not likely to be
productive. If I wanted to build a search function that looked for "IF(" in
every language version of Excel, what would be the best way of doing this?
Would I:

1) create a sub that recognises what language version I am in, then pass the
correct function spelling for that function in that langauge to a variable
and search on it
2) Or are the functions just simply backed by a general library that can be
referenced (say a ref number that is common to all IF statments in all
languages versions of Excel?

If need be where can I get the function names across all languages?


Thanks
.

Relevant Pages

  • Modify windows language using VBA
    ... I have a program that modify the windows language inside Excel. ... lpReserved As String ... Private Declare Function WaitForSingleObject Lib "kernel32" (ByVal _ ...
    (microsoft.public.excel.programming)
  • Modify windows language from VBA Code
    ... I have a program that modify the windows language inside Excel. ... lpReserved As String ... Private Declare Function WaitForSingleObject Lib "kernel32" (ByVal _ ...
    (microsoft.public.word.vba.general)
  • Re: VB for Excel/Foreign OS
    ... assign it to a STRING variable and you'll see. ... > When I run this macro on a machine with Excel 2000 (fully patched ... > with Office Updates) running on a Windows XP (U.S. ... > I guess I would have presumed that the OS language would not affect ...
    (microsoft.public.excel.programming)
  • Re: Where can I find the Function names in other languages
    ... >I have a function that searches on a string that makes up a function name ... > If I am doing this in a version of Excel that is not English say French, ... > IF Statment will likely not be the english IF. ... > every language version of Excel, what would be the best way of doing this? ...
    (microsoft.public.excel.programming)
  • Re: Where can I find the Function names in other languages
    ... >> If I am doing this in a version of Excel that is not English say French, ... >> IF Statment will likely not be the english IF. ... >> 1) create a sub that recognises what language version I am in, ...
    (microsoft.public.excel.programming)