Saving in Tab Delimited

SouthernAZ · #1 (**permalink**) 01-21-04, 13:55

How would you save an Excel worksheet as a Tab Delimited file using VBA?

Thanks

shades · #2 (**permalink**) 01-21-04, 14:20

One line:

Code:

ActiveWorkbook.SaveAs Filename:= _
        "C:\Documents and Settings\...\~~Working Folder\Book1.txt", _
        FileFormat:=xlText, CreateBackup:=False

shades · #3 (**permalink**) 01-21-04, 14:29

Keep in mind that .txt files can only have one sheet (not the multiple ones in Excel).

Internet Services

Web Development

Digital Marketing

Consumer Tech