TXT format
 

Hi,

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

Tom

TXT format
 

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

TXT format
 

activeworkbook.SaveAs "C:\Mybook.prn", Fileformat:=xlTextPrinter

--
Regards,
Tom Ogilvy

"Tom" wrote in message
...
Hi,

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

Tom

TXT format
 

If you do a Workbook.SaveAs you can specify the file format you want. I
assume you want either xlTextMSDOS, xlTextWindows, or xlUnicodeText. The
simple form is:
ThisWorkbook.SaveAs("SaveFile.txt", xlTextWindows)
But for full details see Excel VBA help on the SaveAs method.

"Tom" wrote:

Hi,

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

Tom

TXT format
 

Dosnt work, there are still TABs.


"K Dales" wrote in message
...
If you do a Workbook.SaveAs you can specify the file format you want. I
assume you want either xlTextMSDOS, xlTextWindows, or xlUnicodeText. The
simple form is:
ThisWorkbook.SaveAs("SaveFile.txt", xlTextWindows)
But for full details see Excel VBA help on the SaveAs method.

"Tom" wrote:

Hi,

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

Tom