Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I export Excel in a semi-colon delimited format?
I would like to export an Excel worksheet in a semi-colon delimited format
instead of a comma delimited format. Is that possible? |
#2
|
|||
|
|||
See Chip[ Pearson';s site for code.
http://www.cpearson.com/excel/imptext.htm#Export Gord Dibben Excel MVP On Fri, 6 May 2005 14:28:12 -0700, "Robert1105" wrote: I would like to export an Excel worksheet in a semi-colon delimited format instead of a comma delimited format. Is that possible? |
#3
|
|||
|
|||
Robert,
Try the Text Write Program at www.smokeylake.com/excel. Put a semicolon in the Field Delimiter field on the setup sheet. Then go to your sheet, press Ctrl-Shift-W, and let 'er rip. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Robert1105" wrote in message ... I would like to export an Excel worksheet in a semi-colon delimited format instead of a comma delimited format. Is that possible? |
#4
|
|||
|
|||
Thanks for the assistance. I will look these up see how they help.
"Earl Kiosterud" wrote: Robert, Try the Text Write Program at www.smokeylake.com/excel. Put a semicolon in the Field Delimiter field on the setup sheet. Then go to your sheet, press Ctrl-Shift-W, and let 'er rip. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Robert1105" wrote in message ... I would like to export an Excel worksheet in a semi-colon delimited format instead of a comma delimited format. Is that possible? |
#5
|
|||
|
|||
Hi Earl
Great job. Two things that would be great, if I may. 1) I like the browse button, but that is for opening a program. You might want to label it as such. I was looking for a way to change the folder the file saves in. Which, due to proximity, was what I expected. You should put a mention in that the output is saved relative to your file, not the source. 2) I would like to have delimiters around empty cells in rows. It would be nice, especially if you define an explicit area for export. Some rows have all columns filled, others do not. I see that it puts in delims if there is a non-empty cell a few columns over to the right. The other idea would be for the macro to scan the worksheet, determine the right-most column used and then rip the sheet. Thanks Pete "Earl Kiosterud" wrote: Robert, Try the Text Write Program at www.smokeylake.com/excel. Put a semicolon in the Field Delimiter field on the setup sheet. Then go to your sheet, press Ctrl-Shift-W, and let 'er rip. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I export data from Excel into an ODBC client / or plain tex | Excel Discussion (Misc queries) | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
How do I export XLS to TXT delimited by '|'? | Excel Discussion (Misc queries) | |||
saving excel file as tab delimited | Excel Discussion (Misc queries) | |||
how do I export an Excel graph to an encapsulated postscript (.ep. | Charts and Charting in Excel |