the fileformat includes the delimiter in this case.

--
Regards,
Tom Ogilvy

"Glen Mettler" wrote in message
...
I need to save and xls file as a tab delimited text file
This is my code:
ActiveWorkbook.SaveAs Filename:=filetosave, FileFormat:=xlText

is the default delimiter a tab or do I need to add another parameter?

Glen