Web Scraping Using Excel VBA - Series 16

What you'll learn
How to scrape website pages step by step.
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 downloading the files from website
from clicking on the links to scrape web page tables using different ways
Requirements
You should have a basic idea about VBA Like using variables. if conditions and Collection loops.
Description
Web Automation via Internet Explorer - No more manual stuff. It can be done using automation now.

Learn about Web Scraping using VBA in internet explorer

Basic to Advance Level Course

How to work with A tags

How to work with Class Tags

How to work with input tags,ID tags

What is a class in HTML and how and why we create them in HTML

What is a document , its class and document elements - object hierarchy discussion

How we can click on links in website

How to put the information in website forms

How to download the excel or csv files from internet

Assignments for you to practice

How to debug the program if you are not able to click on link despite it is available on web page

Use of immediate window to see more properties of tags like A tag,ID,Class,input, headers etc.

Export tables details in excel from a web page

How to work with already opened web-pages

Who this course is for:
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.

Screenshots