Hi Tom

See Chip's code at
http://www.cpearson.com/excel/imptext.htm
scroll down to the Export part of the page.

HTH. Best wishes Harald

"Tom" skrev i melding
...
Hi,

how can I save sheets from VBA in .txt format withou any TAB delimited ?

Tom