Tag: vba

In VBA, How can we get data shown up with “Inspect Element”, but not with “View Page Source”?

getattribute getelementbyid getelementsbytagname javascript vba

I am trying to scrape a web page which includes multiple tabs. I want to get the quarterly data which is displayed when clicking on By-Quarter Tab, but my code keeps returning yearly data shown when clicking By-Year Tab. The problem is both types of data are on the same URL and when right-clicking “Inspect Element”, their IDs are also

Web scraping data displayed inside button with no name

excel javascript vba web-scraping

I’m trying to extract values stored inside different buttons on the webpage. It seems button of each variant has no name, they are just called “variant__box”, which are under “variants” div class. As far as I can tell, values are loaded by javascript on each variant__box. This is the website to get the data: https://www.honda.co.uk/motorcycles/range/adventure/crf1100l-africa-twin-adventure-sports/specifications-and-price.html#/ This is the code I’ve