save as CSV - changing delimiter

[george m]

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

Can this be done with a macro?

 

[dlw]

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

 

[george m]

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

 

[Gord Dibben]

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

 

[Dave Peterson]

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.

 

[David Biddulph]

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

 

[Dave Peterson]

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.