save as CSV - changing delimiter
 

I need to save a file as CSV, But I need the delimiter to be a semicolon (;)

Can this be done with a macro?

save as CSV - changing delimiter
 

might be easier just to pull it into notepad and do a search/replace

"george m" wrote:

I need to save a file as CSV, But I need the delimiter to be a semicolon (;)

Can this be done with a macro?

save as CSV - changing delimiter
 

I need to code this is a macro. becuase this is a spreadsheet that gets used
by many users.
I would like to automate the process

Thanks
GM

"george m" wrote:

I need to save a file as CSV, But I need the delimiter to be a semicolon (;)

Can this be done with a macro?

save as CSV - changing delimiter
 

Earl Kiosterud's free TEXTWRITE.xls workbook will do what you want.

http://www.smokeylake.com/excel/text_write_program.htm


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 11:38:03 -0800, george m
wrote:

I need to save a file as CSV, But I need the delimiter to be a semicolon (;)

Can this be done with a macro?

save as CSV - changing delimiter
 

Here are three sites that you could steal some code from:

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

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

Earl's program may work right out of the box.

george m wrote:

I need to save a file as CSV, But I need the delimiter to be a semicolon (;)

Can this be done with a macro?

--

Dave Peterson

save as CSV - changing delimiter
 

Have you tried going into Windows/ Regional Settings, and changing the list
separator?
--
David Biddulph

"george m" wrote in message
...
I need to save a file as CSV, But I need the delimiter to be a semicolon
(;)

Can this be done with a macro?

save as CSV - changing delimiter
 

If I were the only one using the macro, that's what I'd do--even if I had to do
it before each macro run.

But if I had to share it with others, I wouldn't do it.

David Biddulph wrote:

Have you tried going into Windows/ Regional Settings, and changing the list
separator?
--
David Biddulph

"george m" wrote in message
...
I need to save a file as CSV, But I need the delimiter to be a semicolon
(;)

Can this be done with a macro?




--

Dave Peterson