VBA scraping of HTML

Hi all,

Currently I have got a VBA which scrapes through links and tables that are stored inside sheet called web_links. But if you check sheet web_data the data is a little off the columns not where it should be. My question would be how can I update this VBA so it only downloads data from tables with the following ID's: product-name, price-box?

Please Login or Register  to view this content.

Ok, let me simplify the question a little.

How do I return price from the class below:

Capture.PNG

I tried to use the VBA below but it is returning me the error code 438 object doesnt support this property or method.

Desired outcome should be a massage box showing 75.21 inside.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Ok, that makes sense. But how do I loop right now through all of the regular-price classes on this link and put them all together into the long string so I can split it later?

Please Login or Register  to view this content.

I am going to shoot off un momento and will not check in until tomorrow.
Loop through the regular price class, but you need to cut and slice the text as some of them have a "Price" word attached to them.

Please Login or Register  to view this content.