Import HTML code from a text file.

[nathpai]

I am getting the html code of a wab page in a variable which I have
written to a file and saved as a .txt file. I am importing these code
in excel for further processing.

Is there a better way to write these code to excel sheet? Each line for
code should be in new row in column A. Currently opening the file in
excel writes the code in other columns if the code has indenting.
Also if I can avoid creating a text file and then importing in Excel,
it would be better and faster I belive. Can I perse the html code
directly from the variable and write each line of code in col A new
rows?


Thanks.
Nathpai

 

[OJ]

Why don;t you save as HTML and then import into Excel as HTML?

 

[nathpai]

Thanks for reply.
I have tried it just now. If I import the html in excel, Nothing is
imported. Excel just shows the blank sheet. The same file if I open in
IE, it opens after giving few script errors. But still for the same
HTML file when opened in excel, shows a blank sheet.

I have no idea why it happens this way.
Thanks,
Nathpai.