Posted to microsoft.public.excel.programming

Stephen Bullen[_4_] Stephen Bullen[_4_] is offline

external usenet poster

Posts: 205

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel not using regional settings	Dweezil38	Excel Discussion (Misc queries)	6	March 15th 11 08:50 AM
Regional settings	Ana via OfficeKB.com	Excel Worksheet Functions	1	October 27th 09 02:41 PM
regional settings	Spike	Excel Worksheet Functions	5	July 29th 07 01:10 AM
Regional Settings	LAF	Excel Discussion (Misc queries)	2	July 30th 05 12:51 PM
Changing Regional Settings from VBA	Michael Rekas[_2_]	Excel Programming	3	May 18th 04 09:05 AM

All times are GMT +1. The time now is 01:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us