Web Data Scraping using Excel VBA

Name: Web Data Scraping using Excel VBA
Rating: 4.5 (74 reviews)

Web automation using VBA and IE

Created byKamal Girdher

Last updated 8/2020

English

English [Auto],

What you'll learn

You will learn how to do data scraping and create scraping applications in excel (macros/vba).

Course content

4 sections • 17 lectures • 1h 57m total length

Course Overview & Disclaimer1:15
A quick overview of the course and the disclaimer that scraping is illegal. You should do this only for the websites for which you have the authority to do so.

Music credits : bensound.com

SubProcedures & Functions6:24
Learn how sub procedures and functions work in vba, including scope, private vs public access, passing arguments, and returning values with practical message box examples.
Variables and Objects10:29
Conditional statements5:28
Loop statements10:07
Bonus Lecture - String Operations8:29
Explore string operations in Excel VBA for web data scraping, using Len, Left, Right, Mid, Split and Join to extract, split, and format strings with arrays and loops.

HTML overview [Optional] - for beginners only17:57
Microsoft Internet Controls & Microsoft HTML Object Library3:22
Explore automating Internet Explorer with Excel VBA using Microsoft Internet Controls and the Microsoft HTML Object Library to navigate pages and interact with page elements by ID, name, or tag.
Open/close browser and launch url1:22
Launch and close a browser in Excel VBA by creating an Internet Explorer object, making it visible, and navigating to a URL, then quitting the browser.
Control already open browser (IE)4:23

Types of web Elements2:42
Introduction to HTMLDocument1:54
Learn how HTMLDocument and the document object represent the page, manage load times with a hardcoded five-second wait, and access elements using methods like element by id.
Object Identification techniques8:02
Identify elements using id, name, and tag name locators; manipulate text boxes, a combo box, radio buttons, and checkboxes with Excel VBA in web scraping.
Form automation & Browser Readystate5:42
Fill form in loop with different data9:19
Data extraction from website - Example 110:51
Explanation | Access elements on page | Javascript console and VBA9:32

Requirements

Yes. Excel VBA knowledge is required. Plus, basic knowledge of web dom structure is required. Don't worry, we have free tutorials for this on my youtube channel "Extreme Automation - Kamal Girdher"

Description

In this course, you'd learn how to automate steps on a website to do your form filling job or data scraping work. You need to have good command over Excel and VBA before you start this course. You can refer my free course about Excel VBA on my youtube channel "Extreme Automation - Kamal Girdher"

Happy Learning!

Who this course is for:

Data scientists, VBA developers, Excel lovers, Professionals, Data experts, Sales/Marketing people.

Web Data Scraping using Excel VBA

What you'll learn

Explore related topics

Course content

Course Overview & Disclaimer1 lecture • 1min

VBA refresher [Optional]5 lectures • 41min

Web Scraping Libraries(references) & launch operations4 lectures • 27min

Web Automation using Excel VBA7 lectures • 48min

Requirements

Description

Who this course is for: