Need help saving as tab-delimited file

  • Thread starter Thread starter monica
  • Start date Start date
M

monica

I have been saving a worksheet in my Excel file as comma-
delimited using VBA like this:

ThisWorkbook.SaveAs "FileName", xlCSVWindows

How do I save as tab-delimited text file instead? Isn't
there something to put in place of "xlCSVWindows"?

Thanks in advance!
 
An easy way to find out is to turn on the macro recorder and do you save

ActiveWorkbook.SaveAs Filename:="F:\AAAAA\Book4.txt", _
FileFormat:=xlText, _
CreateBackup:=False

so the answer is xlText
 
Back
Top