Hello,
I have interesting problem.....I have some sheets with datas.When I manualy
"Save as" TXT file (and record macro) evrythnig is ok.
Then when I used this record there is problem in exported TXT file. When I
open it there are in some places quotation marks "
I am getting crazy do you know somebady why?

Thanks Tom

I find out solution:

ActiveWorkbook.SaveAs Filename:="test.txt", _
FileFormat:=xlTextMSDOS, CreateBackup:=False, Local:=True

Local:=True - this is important.

Tom