Save file as text pipe delimited
 

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