Web Scraping Using Excel VBA
Web Automation made easy with VBA
4.53 (61 reviews)
461
students
8 hours
content
Jul 2022
last update
$64.99
regular price
What you will learn
How to scrape website using Internet explorer browser.
Complete tutorial from basics to advance - Using VBA
You will learn everything - from clicking on website links to putting the information in web forms.
From debugging the issues to clicking on the links to scrape web page tables using different ways
How to launch a website but before launching the website, know the libraries we need it.
If website takes time to load how to keep code busy in events to avoid it going forward and then throw errors.
Work with attributes like name, id and what is their significance.
Work with important tags like a tags which helps in clicking on those links which has hyperlinks.
How to loop through all elements using collection loop or how to find out the specific element and then work with only that one
How to scrape table data into excel. How to target few or each and every table using loops.
Work with table , tr, th and td tags in one go or how to be specific about it.
How to do login on website using above knowledge and click on data calendar controls, fill the userform information on websites.
How to download files using API technique.
How to maximize webpage if needed
Projects also discussed for more confidence.
Learn the collection loops with the logics. Know difference between collection element and single element.
Screenshots
Related Topics
2540898
udemy ID
9/3/2019
course created date
2/8/2020
course indexed date
Bot
course submited by