Open hyperlinks from Worksheet and import their data

[leeksleeks]

Hi,

I have a worksheet with a series of clickable hyperlinks to a webpage with the information I am after. Is there some code to loop through each hyperlink and import the data from the webpage that it opens?

All my Hyperlinks are in column B however some cells are blank so I would like the code to skip any blank cells and move down to the next one until there are no more to import.

I thank you in advance!

 

[sijpie]

Maybe by using data queries as described here:
MS Excel Web Query Secrets Revealed