Identifying the Users Regional Settings and Windows Language

Everything you need to know about your user's Windows Regional Settings and Windows language version is found in the Application.International property. The online help lists all of the items that can be accessed, though you are unlikely to use more than a few of them. The most notable are:

□ XlCountryCode: The language version of Excel (or of the currently active Office language)

□ XlCountrySetting: The Windows regional settings location

□ XlDateOrder: The choice of month-day-year, day-month-year, or year-month-day order to display dates

Note that there is no constant that enables you to identify which language version of Windows is installed (but you can get that information from the Windows API if required).

Windows Regional Settings is abbreviated to WRS in the rest of this chapter, and is also described as local settings.

0 0

Post a comment