Write Command Output
"?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 |
All times are GMT +1. The time now is 11:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com