Web Scraping Using Excel VBA

Web Automation made easy with VBA

Created by: ajay parmar
Instructor -Excel,Vba ,Access, Access Vba,BI,PQ,G SHEETS

What Will I 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.

Requirements

• You should have a basic idea about VBA Like using variables. if conditions and Collection loops.

Target audience

• Students or working professionals who want to learn how we can control or automate our website day to day tasks.
• Do you not wish to open the website on its own and then fill your form inputs.
• how about downloading the files or clicking on menus on website.