General discussion


Save xls file as pipe delimited txt

By AshleyE ·
I have a macro that saves the excel spreadsheet as a txt file at the end:
ActiveWorkbook.SaveAs Filename:= _
"O:\CSMIS\Enhancements\Generic Auto
Upload\SampleCSMISUpload_Renewal.txt", _
FileFormat:=xlText, CreateBackup:=False

However, I would like to save it as a text file - pipe
delimited rather than the default tab delimited.
Does anyone have a suggestion of how to do this?

I found this code to change the delimiter to #, but I am
not sure how to incorporate.
..TextFileOtherDelimiter = "#"

Any help would be much appreciated. Thanks in advance!

- Ashley

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums