| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving a worksheet to csv with different separator
Hello, I want to save a csv or text file from excel 2000 but using | as
separator. However I can not find option to chose the separator ... any advise welcome and appreciated |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Saving a worksheet to csv with different separator
For one way, see
http://www.mcgimpsey.com/excel/textfiles.html In article . com, "bazza1" wrote: Hello, I want to save a csv or text file from excel 2000 but using | as separator. However I can not find option to chose the separator ... any advise welcome and appreciated |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Saving a worksheet to csv with different separator
thanks you for taking tiome to respond, the macro enables us to save
with selected delimiter, can I ask one more question -- is it possible to save in this way also using the file...save as... options through menu ? by setting the chosen character as default separator ? many thanks JE McGimpsey wrote: For one way, see http://www.mcgimpsey.com/excel/textfiles.html In article . com, "bazza1" wrote: Hello, I want to save a csv or text file from excel 2000 but using | as separator. However I can not find option to chose the separator ... any advise welcome and appreciated |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Saving a worksheet to csv with different separator
Not using XL's File/Save As...
One could use event code in a workbook or add-in to reassign the Save As command to a customized routine, but it would be rather more complex than just setting a default separator. In article .com, "bazza1" wrote: thanks you for taking tiome to respond, the macro enables us to save with selected delimiter, can I ask one more question -- is it possible to save in this way also using the file...save as... options through menu ? by setting the chosen character as default separator ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems saving a worksheet with links to a New Location | Excel Worksheet Functions | |||
| Problems saving a worksheet with links | Excel Discussion (Misc queries) | |||
| One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
| Saving into 1 workbook as a different worksheet | Excel Worksheet Functions | |||
| Keeping Worksheet tab colors when saving as web page | Excel Discussion (Misc queries) | |||
Linear Mode
