Scrape website using VBA

Hi folks

I have a list of product page URLs from a website, stored in Column A
Example page: http://www.crazyprofit.co.uk/High_Qu...1408140916.htm

In columns B-D I would like to scrape the following data
B: Product Name (Heavy Duty Samsung Cables-7255 on example page)
C: Price (£3.29 on example page)
D: Optional added shipping charge (£1.50 on example page once selected from drop down menu)

I know there's a way to get the data that I require in columns B & C, using VBA, I'm clueless at writing functions though

Any help would be greatly appreciated!

Hi,

see from a worksheet New query on the Web (QueryTable in VBA) …

Other beginner level way but with internet skills : Automate Internet Explorer …

More efficient but at advanced level : requests !

Many sample of each way in this forum …

Nice one Ross!, that sheet does exactly what I'm needing, thanks a bunch!

lol, If you've even spent as much as 10 minutes learning Gaelic then you'll know a bit more than me!

I Live in Central Scotland and English is the language we use (Although in recent years there have been more and more people speaking Polish, Lithuianian, Hungarian, Bulgarian etc as the country fills up with Eastern European immigrants)

Fact: There are a lot more Polish speaking people in Scotland than there are Gaelic