I found each line of output being cut off after 55 characters when I used
FileFormat:=xlTextPrinter. No idea why.

But the textstream object avoided that problem.
In particular, this code snippet (from excel help) works:
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.CreateTextFile("c:\testfile.txt", True)
a.WriteLine("This is a test, and this is a test!")
a.Close


"Warzel" wrote:

Tom Ogilvy wrote:
Why do you say Anyway

I suggested:

You can probably export as space delimited and it shouldn't put in the

double double quotes

Which is what you say is the solution.

i'am sorry. you are wright as you indeed suggest the space delimited
option. So i stand corrected and thank you not anyway but all the way