Saving a worksheet to csv with different separator

B

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
 
B

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top