I work in a multi cultural office, which is causing issues with some
functions and code that I am using in a workbook I have created, which is
used by many different people in my office.

How can I best read which language setting the current user has on their pc
and return this information to a specific cell in my workbook?

We are currently running excel 2003, but if the solution is different I
would also like the answer for 2007, as we are intending to upgrade in the
near future.

Thanks for the help with this.

Richard

application.International(xlcountrycode) - Country/Region version of
Microsoft Excel

application.International(xlcountrysetting) - Country/Region setting in the
Windows Control Panel

you will need to decode them

--
__________________________________
HTH

Bob

"Richard" wrote in message
...
I work in a multi cultural office, which is causing issues with some
functions and code that I am using in a workbook I have created, which is
used by many different people in my office.

How can I best read which language setting the current user has on their
pc
and return this information to a specific cell in my workbook?

We are currently running excel 2003, but if the solution is different I
would also like the answer for 2007, as we are intending to upgrade in the
near future.

Thanks for the help with this.

Richard

Thats Great

Many Thanks

"Bob Phillips" wrote:

application.International(xlcountrycode) - Country/Region version of
Microsoft Excel

application.International(xlcountrysetting) - Country/Region setting in the
Windows Control Panel

you will need to decode them

--
__________________________________
HTH

Bob

"Richard" wrote in message
...
I work in a multi cultural office, which is causing issues with some
functions and code that I am using in a workbook I have created, which is
used by many different people in my office.

How can I best read which language setting the current user has on their
pc
and return this information to a specific cell in my workbook?

We are currently running excel 2003, but if the solution is different I
would also like the answer for 2007, as we are intending to upgrade in the
near future.

Thanks for the help with this.

Richard