Help with SaveAs
 

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

Help with SaveAs
 

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

Help with SaveAs
 

The default for xlText is a Tab, so you do not need another parameter. Try
it and take a peek at the file using a wordprocessor.

--
Cheers
Nigel



"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