Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pipe-Delimited CSv File | Excel Discussion (Misc queries) | |||
How can I convert tab delimited files to pipe delimited? | Excel Discussion (Misc queries) | |||
Save CSV file as Pipe delimited text file | Excel Discussion (Misc queries) | |||
Import Pipe Delimited File, Parse out certian Fields, create new f | New Users to Excel | |||
How can I save a file as a comma-delimited text file in Excel? | Excel Discussion (Misc queries) |