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

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

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

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 ?