Web Scraping Using Excel VBA

Web Automation made easy with VBA

0 0

Web Automation made easy with VBA

Webscraping means how to get the information from any website without doing any manual handling.
You will be able to download the data from a website or click on buttons or get the paragraphs content, tables contents and so much.
This course will teach you how to do the Web Automation via Internet Explorer - No more manual stuff. It can be done using automation now. Please note it is going to be done only by internet explorer
Learn every thing about loops use and if conditions in Web Scraping using VBA in internet explorer
This course is Basic to Advance Level Course so you can definitely join it but it does not discusses vba basics.
How to work with A tags
How to work with Class Tags and what are the class tags. What type of issues one can face while dealing with classes is also something we have discussed.
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