Hi
have a look at
application.international
in the VBA help

--
Regards
Frank Kabel
Frankfurt, Germany

"novice2005" schrieb im
Newsbeitrag ...

Hello,

I have an excel workbook that outputs a file with numbers and
currencies. Since this Workbook is used globally and each region has
its own regional setting, specifically digit grouping and decimal
symbols interchanged. On creation the output file, the
numbers/currencies contain the decimal & digit grouping symbols as
their regional settings. But the file needs to contain decimals as
dot
and digit grouping as comma.

Before outputting the file, can we check the regional settings and if
its different from what is required, then change it and once the file
is created revert it.

Please let me know if its a good option and if not suggest better
ones.

Thanks.


--
novice2005
---------------------------------------------------------------------
---
novice2005's Profile:
http://www.excelforum.com/member.php...o&userid=16406
View this thread:
http://www.excelforum.com/showthread...hreadid=277752