how to read from a text file and write to an excel

[kramesh]

I need to write a macro to read a text file with the following format and write to an excel worksheet.

id subject state
123 test open
344 test3 assign

Thanks

 

[babycody]

Try Data> Import external data> Import data. Then use Data>Text to columns to seperate the information into columns.