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