Regional Settings with VBA - Urgent
 

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

--
novice200
-----------------------------------------------------------------------
novice2005's Profile: http://www.excelforum.com/member.php...fo&userid=1640
View this thread: http://www.excelforum.com/showthread.php?threadid=27775

Regional Settings with VBA - Urgent
 

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

Regional Settings with VBA - Urgent
 

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.

I've tried this and never got it to work satisfactorily.

--
Jim Rech
Excel MVP
"novice2005" wrote in message
...

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

Regional Settings with VBA - Urgent
 

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

--
Regards,
Tom Ogilvy

"novice2005" wrote in message
...

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

Regional Settings with VBA - Urgent
 

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