Refer to Chip Pearson's website...

http://www.cpearson.com/excel/imptext.htm


"violet" wrote in message
...
i wish to noe is there any way that i can write a macro to copy data from
another type of file to my excel spreadsheet. eg. a system generate a
report
in html file or text file..den i will like to copy data generated from the
report to my excel.is that possible?