"?B?RGFuIFQ=?=" .(donotspam) wrote:

The write to text file command exports in CSV, is there a way to
change this so it writes to Tab Delimited?



note that when you save a CSV file Excel has a very strange idea of
comma's.. it will use the locale's listseparator..


for tab delimited you could use ...

ActiveWorkbook.SaveAs _
Filename:="Book1.txt", FileFormat:=xlText

but if you want more control, you'll have to do some programming:

more info pleaese read:

http://www.mcgimpsey.com/excel/textfiles.html


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool