Saving a worksheet to csv with different separator

[bazza1]

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

 

[JE McGimpsey]

For one way, see

http://www.mcgimpsey.com/excel/textfiles.html

 

[bazza1]

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]

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.