Web Scraping With VBA | Scraping Data Tables

We’ve seen how to use VBA to scrape different web pages, but one topic we haven’t covered is how to parse HTML tables that exist on those pages correctly. With this video, we will scrape a Star Wars table found on Wikipedia and import it into Excel. If you are new to this topic, please watch the first video in this series as there are specific topics that are required to understand this video in its entirety. Video Resources: -------------------------------------------------- Resource: GitHub File Link: https://github.com/areed1192/sigma_coding_youtube/tree/master/vba/vba-advanced/web-scraping/WebscrapingTables.bas Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub Sigma Coding: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: How To Programmatically Add Library References Using VBA Link: https://youtu.be/ri8Kzwu6aqU Title: How to Work With the Command Bar Object in VBA Link: https://youtu.be/nMZvFzVIW-c Title: How to Work With the Command Bar Control Object in VBA Link: https://youtu.be/LsCoII_VZMk Title: How to Export Macros Using VBA Link: https://youtu.be/6VoiGoCASrU Title: How To Run A Python Script Using Excel VBA Link: https://youtu.be/rlHcrAb2_fs Title: How to Use the Shell Automation Library in VBA | Part 1 Link: https://youtu.be/Hqt1rs1bth8 Title: How To Control The Visual Basic Editor With VBA Link: https://youtu.be/tv4Ext49i24 Title: Web Scraping With VBA | Part One Link: https://youtu.be/inXUOu5bwAE Title: Web Scraping With VBA | Part Three Link: https://youtu.be/jDd1u1Q0xMs Title: Web Scraping With VBA | Part Two Link: https://youtu.be/7_9gRf4lC0g Title: Web Scraping With VBA | Scraping Data Tables Link: https://youtu.be/Z7XwlH6Mes4 Title: Making API Requests in VBA | JSON Link: https://youtu.be/BRB2SlsBEUI Title: Making API Requests in VBA | XML Link: https://youtu.be/2SwWRg8-BvE Title: How To Pull Data From Access Using VBA Link: https://youtu.be/5kIUPFWsNYw Title: Importing Text Files In VBA Link: https://youtu.be/o8jcNHxLDSw Title: How to Use the File System Object in VBA Link: https://youtu.be/I05NXLUh0Co Title: How to Build Windows Forms Applications in Python | Pt. 2 Link: https://youtu.be/Qc019p2Ptc4 **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #Excel #VBA #Webscraping