Excel saves CSV using semicolon(;) instead of comma(,)
 

When I save my file as csv , Excel inserts semicolon instead of comma.
I have already read that its related with my regional settings(Portuguese).
How can i change the regional settings, using macro?
The macro needs to work in Excel 2000, XP and 2003.

--
Thank you
Daniel Amorim

Excel saves CSV using semicolon(;) instead of comma(,)
 

Maybe just writing your .CSV file the way you want would be better than changing
a windows setting on other people's pc.

Here are some sites with sample code:

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

Daniel Amorim wrote:

When I save my file as csv , Excel inserts semicolon instead of comma.
I have already read that its related with my regional settings(Portuguese).
How can i change the regional settings, using macro?
The macro needs to work in Excel 2000, XP and 2003.

--
Thank you
Daniel Amorim

--

Dave Peterson