Web automation using VBA and IE
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!
English
language
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