Save file as text pipe delimited

A

Ashley

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
 

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

Similar Threads

Create Tab delimited file with no quotes in Currency fields. 0
Saving as Sheet as a Tab Delimited Text file 2
Save Macro with date in name 1
SaveAs *.txt - Outputting with Text quantifiers 4
Import Text file with Pipe Delimited - 2007 4
Import Using Pipe as Delimiter 4
Text to Rows 0
Adding a new file extension for Pipe Delimited files 3

Top