If you want the data all in one line then you need to alter the file
before saving out to a *.txt file - The output depends on what the data
source.
The xlTextPrinter will just stop the quotations around text.
Charlie.B

stevieb wrote:

This does not output into one line.

"CB" wrote:


Very simple -
Change to: FileFormat:=xlTextPrinter
Regards
Charlie.B


Hello,

I am trying to export a worksheet as a *.txt file but do not want the text
quantifiers to appear (ie. the quotations around the text columns).

Here is a snippet of my saveas code:
ActiveWorkbook.SaveAs Filename:=mylocation , _
FileFormat:=xlText, CreateBackup:=False

Do I either have to change the format of the columns before I use the SaveAs
or can I mod the SaveAs function (ie. use a different paramter or try
different FileFormat's.)

Thanks,
-Steve

.