Hi,
I have Excel 2000 on Win 2000 and I am trying to save the active
worksheet as a tab delimited file. This is what I've tried:
Dim i As Integer
Dim ws As Worksheet

ws = ActiveWorkbook.SaveAs("13031t.txt", xlTextWindows)

But I keep getting an error on the "Saveas" saying it needs a valid
function. So how do I do this?

Also, what is the file format for a tab delim file? Excel VBA help
does not say, it just lists the file format constants.

Thanks

--
Say no to fixed width tables. They look terrible in all browsers.