| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the default delimiter | Excel Discussion (Misc queries) | |||
| Excel: save-as csv : delimiter set to semi-colon, not comma. Why? | Excel Discussion (Misc queries) | |||
| Save as changing links in other workbooks | Excel Discussion (Misc queries) | |||
| How can I save Excel am spreadsheet as pipe delimiter? | Excel Discussion (Misc queries) | |||
| Changing Export Delimiter | Excel Discussion (Misc queries) | |||
Linear Mode
