"?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