Unless I've missed the point,
File|Save As...
then in the 'Save as type:' field one of the options is:
Text(Tab delimited)(*.txt)
Pressing OK then results in a 'The selected filetype does not support
workbooks that contain multiple workbooks. To save  only the active
sheet click OK', which is fine for you. Pressing OK here results in
another warning about losing excel  features not compatible with tab
delimited text  files; this is what Help had to say about the format:

"The Text (*.txt) file format  saves only the text and values as they
are displayed in cells of the active worksheet. All rows and all
characters in each cell  are saved. Columns of data are separated by
tab characters, and each row of data ends in a carriage return. If a
cell contains a comma, the cell contents are enclosed in double
quotation marks. All formatting, graphics, objects, and other
worksheet contents are lost."

Since you've used 'Save As', then you can go back to your original
file, so nothing to worry aboout. Clicking 'Yes' here results in the
file being created. Opening this file  in NotePad confirmed that it was
indeed tab  delimited.

I recorded a macro of my doing this and got:

ActiveWorkbook.SaveAs Filename:="C:\Book3.txt", _
FileFormat:=xlText, CreateBackup:=False