Thread: Exporting selection to tab delimited text file

Hi,

I have a worksheet (In a workbook with several sheets) that I want to save to a tab delimited text file.

I want to include the full range of data on the worksheet except the header row.

Currently I can't even figure out how to achieve this without a macro, so I've not even been able to record and modify the action.

Any help?

Many thanks

Something like this:

Sub test()

ActiveSheet.Copy

Rows(1).Delete

ActiveWorkbook.SaveAs Filename:="C:\Export.txt", FileFormat:=xlText

ActiveWorkbook.Close False

End Sub

If you want to specify a specific sheet the first line would be something like:

Sheets("Sheet1").Copy

Dom