Extract text data from web pages

[stuey_adz]

Hi All,

New to the forum and excel programming in general.

I have a column of HTML hyperlinks (1700 in total) for mainly online news articles.

I wish to extract the text data from these sites and import them into excel.

What is the quickest way of achieving this? I imagine it will be to write a macro that follows the HTML link in every cell and exports the text data somewhere.

Any help is much appreciated and sorry if I've posted this in the wrong place!

Thanks

[mrice]

You may get some hints from these links.

http://www.excely.com/excel-vba/ie-automation.shtml

https://stackoverflow.com/questions/...body-innerhtml

The innerHTML property is probably what you need.