Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 1 Minute(s)
Language
English
Taught by
ajay parmar
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
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
Course Content
- 1 section(s)
- 17 lecture(s)
- Section 1 Introduction
What You’ll 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.
Skills covered in this course
Reviews
-
DDave
Yet again this is another A* course from Ajay. Much of the material is demystified and clearly explained. The teaching style really suits me and clear guidance is given. Excellent stuff.
-
MManish Badhani
Overall this course is good for beginners. One thing is bothering me that most of the Office web application frameworks are now built on AngularJS. It would be nice if you teach some basics of web scraping from AngularJS framework webpage
-
NNestor David Plascencia Garcia
Great course, but using Internet Explorer nowadays is really outdated, I would recommend to use HTTP requests instead or at least Selenium since IE will be dead in a few months.
-
CChoon Chin Lee
The course is great! It has met my expectations and needs to perform basis VBA Automation on Internet explorer.
