Regional Settings with VBA - Urgent

[novice2005]

Hello,

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

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

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

Thanks

 

[Frank Kabel]

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

 

[Jim Rech]

can we check the regional settings and if its different from what is
I've tried this and never got it to work satisfactorily.

 

[Tom Ogilvy]

You might want to write your own routine to write the files. Here is a
start at Chip Pearson's site:

http://www.cpearson.com/excel/imptext.htm

 

[Stephen Bullen]

Hi Novice2005,

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.

In Excel 2002 and above, you can set the Application.DecimalSeparator
and Application.ThousandsSeparator appropriately, do your writing, then
set them back. These correspond to the Tools > Options > International
tab.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk