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
Bookmarks