General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Save xls file as pipe delimited txt
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