Need help saving as tab-delimited file
 

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!

Need help saving as tab-delimited file
 

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

--
Regards,
Tom Ogilvy

"monica" wrote in message
...
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!