> This can be done in fact I am also currently looking nto a similiar
solution.
You can use the adodb object and open recordset by using TXT driver.On
using TXT driver you can select data  from file as if it was a table. Once
you have the data in record set you can put  it in EXCEL file ,I have got the
code from internet but can put it up on 9 Jan.<

Yup...I do it all the time only I prefer to use Word, but Excel works
too...just a little differently but the base is the same.