Web Data Scraping using Excel VBA
Web automation using VBA and IE
4.60 (52 reviews)
2,330
students
2 hours
content
Aug 2020
last update
FREE
regular price
What you will learn
You will learn how to do data scraping and create scraping applications in excel (macros/vba).
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!
Content
Course Overview & Disclaimer
Course Overview & Disclaimer
VBA refresher [Optional]
SubProcedures & Functions
Variables and Objects
Conditional statements
Loop statements
Bonus Lecture - String Operations
Web Scraping Libraries(references) & launch operations
Microsoft Internet Controls & Microsoft HTML Object Library
Open/close browser and launch url
Control already open browser (IE)
Web Automation using Excel VBA
Types of web Elements
Introduction to HTMLDocument
Object Identification techniques
Form automation & Browser Readystate
Fill form in loop with different data
Data extraction from website - Example 1
Explaination | Access elements on page | Javascript console and VBA
Data extraction from website - Example 2
Handling pagination while extraction
Screenshots
Reviews
Hussein
January 10, 2023
Very good explanation for Basics, I really like it till now, waiting for the web scraping part . Thanks
Michael
March 27, 2021
The course was good but too dated - Internet Explorer. The teacher was good but some of the example websites were not given or his private so you could not practice some of the exercises.
Tausif
August 10, 2020
Thank so Much for making this course easy to understand.
It was Worth Buying it.?
Would highly recommend to enroll this Course for VBA Leaner.
Soren
June 9, 2020
Good introduction to setup References needed in Excel and how to get Excel to interact with Internet Explorer. Clearly explained how to fill out internet forms with data from Excel for various form objects. Two examples on web scraping data in Internet Explorer.
Giulio
June 2, 2020
Excellent videos for web scraping via Excel. There are two examples. Accessible for those who have a decent knowledge of VBA.
Charts
Price
Rating
Enrollment distribution
Related Topics
2317640
udemy ID
4/11/2019
course created date
7/24/2020
course indexed date
Bot
course submited by