Thanks all. Very helpful. Two last questions.

1)Is it possible to change the setting in my Excel so that it runs in
another language. That is, i want to see it they way the do in other
countries. Or is this a Windows setting. I would like to do some testing
in these other versions. I want to know if it is as simple as flicking a
swich on my own computer.

2)When I reived an excel file from another country (say France), it will
likely be in French. Is it possible in Excel to view that file from my
english windows/excel in English or does it only view in the language that it
orginated in (French)?

Thanks again all!



"ExcelMonkey" wrote:

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