Hi Frank

Great stuff
I hope Chip will add it to his page.

If not I will add it to my webpage if you want

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Frank Kabel" wrote in message ...
Tom
yes it is :-)

--
Regards
Frank Kabel
Frankfurt, Germany


Tom Ogilvy wrote:
From Application.International

xlDateOrder Long Order of date elements:
0 = month-day-year
1 = day-month-year
2 = year-month-day

Is that what you are looking for?


"Frank Kabel" wrote in message
...
Norman Harker wrote:
Hi Frank!

Good one!

Just a thought. Is it possible to determine the style required
without requiring the user to do it?

Hi Norman
thought about that myself but didn't find anything to query the
regional settings. But maybe someone will step in to provide some
code to get the regional settings style for dates

Frank