Scraping A Value Of A Website Using Vba Where The Classname Is Duplicated

Ok This question has a 2 parts to it. I need to scrape the value R1200 from the website into Excel using VBA. I have tried various methods and I cant seem to get it right. @QHarr

Solution 1:

Difficult without test values to enter into the website to generate the values you wish to scrape. Please provide those.

The selector for that value you mention is:

.clearfix.extrasli:nth-of-type(3) span

Though this will select the first element with class name clearfix extras so you may need a different index.

Example for the 4th matching class name:

.clearfix.extras:nth-of-type(4) li:nth-of-type(3) span