Excel VBA Introduction Part 46 - Querying Web Pages using Query Tables
Why Stack Overflow recommends it
Stack Overflow users link it as a starting tutorial for beginners who want to scrape or query websites from Excel VBA.
Recommended by 3 people across 3 different months, 2018 to 2020.
What it is
A 47-minute tutorial from WiseOwlTutorials, presented by Andrew Gould, on pulling web page data into Excel with VBA Query Tables. It covers creating a query table linked to a web page, choosing which HTML tables to return, and passing values into a URL query string for dynamic, refreshable web queries.
What people said
Recommends ashleedawg · 2018-06 · Stack Overflow · on “Website Scraping using VBA”
Can't give much help without knowing what's on the page and which section of your code is the issue. Here's a good tutorial (there are 4 parts in the playlist [this video] .)
Recommends QHarr · 2019-12 · Stack Overflow · on “How to scrape specific part of online english dictionary?”
I would suggest you put aside a day or two to go through some tutorials starting with these: [this video] and [LINK] . You will then be able to more confidently search on StackOverflow for Question/Answers that will help get you started. Also, look into whether there is an API for this.
Recommends TinMan · 2020-12 · Stack Overflow · on “I want to automate excel to search and get result from a website”
These resources will help: Excel VBA Introduction Part 46 - Querying Web Pages using Query Tables [this video] And Excel VBA Introduction Part 47 - Browsing to Websites and Scraping a Web Page [LINK] Excel VBA Introduction Part 48 - Web Scraping Across Multiple Pages [LINK]