VBA Selenium Web Scraping Part 2/2

Name: VBA Selenium Web Scraping Part 2/2
Rating: 4.4 (12 reviews)

Automate Website pages Using Selenium VBA -Google Chrome

Created byajay parmar

Last updated 2/2023

English

What you'll learn

This is Part2 and you are requested to go through Part1 First. In this part2 we are learning how to store cookies data and how to use it practically.
You will learn how to navigate different windows on websites .
How to define the windows or run a collection loop to activate or close them. Its all about fundamentals.
In part1 whatever we have learnt , that all will be used in this project now.
You will get a project from me, A very big and practical project
From attributes like elements by name, or id or classes or its xpath - we will use all and understand them line by line.
From selecting the dropdown and giving code a time to wait for seconds, how loops are going to set up. we will see everything in this project.
how to set up the clickable list of categories in excel and have their status updated as Done in excel.
How to handle recaptcha by letting code wait for few seconds. no need to use paid captcha softwares. Just use basics..
How to avoid relogin if your website creates a issue in frequently log ins or multiple logins .
How to download files from websites and locate them into your folders .
How to take screenshots of websites or excel desktop using image class. Its super fun.
You will learn how to identify if our element is present on webpage or not
What is a By class and how we can use it.

Course content

1 section • 11 lectures • 2h 39m total length

How to handle Cookies data26:06
How to store data in memory using cookies class.
Why it is needed, Any benefits of same. Full discussion on same.
How to check if your object stored any cookie data - using watch window.
A big practical project begins - Simply incredible - Source of inspiration Part122:49
We are going to see how this project has been made. Let us quickly understand first how to click on links and arrive at final page and then to scrape the information we needed.
I am telling you what are the expectations out of this project. What exactly we are going to do in this project. Let us first understand each and everything. You can create your dummy ID for this, if you wish to practice.
Project Continues - Part2 - From login to selecting Drop Down values17:09
We are now starting to work on the project with you looking at the real code made for it.
Line by line , we are understanding the code .From login to clicking on tabs, using xpath, findelementbyid, or name methods, we are learning all. It is actually a revision of whatever we learnt in part1.
Also, we are handling the captcha issue by learning a new command which can let vba code to wait.
Project Continues - Part3 Handle A tags smartly - Logic is superb21:18
Project Continues - Part4 - Select DropDown per page strategy16:41
Project Continues - Part5 -Update Excel sheet with Status Done -Download files8:29
Project Finished -Part6 - Testing by changing the values - You are a master now.9:44
To make sure if code has run yesterday and updated the categories as Done , today if you run the code again, it should not touch those already done cases.
This is how this project automation has been done. You will love it if you learn it by heart. Come on, time to take the challenge and do it from scratch.
How to take window tabs of a Website12:55
How to use collection loop to handle new window tabs16:06
How to take screenshots of a website6:14
Courses with links1:56

Requirements

You should have seen the Part1 Before taking this Part2 course.

Description

First and foremost, this is a Part2. Students must have seen Part1 before.
Students will learn how to download the files
How to add or manage Cookies of a website and how to use it in a practical situation.
How to take screenshots and save those on desktop or export them in excel.
How to launch website new pages in a new window tabs.
Move from first window to second and so on. Challenges and more robust solutions to handle the window tabs.
You will see one of the real data based project which is super duper awesome from learning and getting confidence on webscraping.
We will see how to login to website and how to sort out captcha issues by simply letting code to wait for sometime till user enters captcha.
We will revise our learning in part1 as to how to practically use links using elementbyid, name or class attributes . Also, the best use of Xpath.
if page refreshes for a long time or uncertain , how to put a wait time.
You will see the use of magnificent loops and IF Conditions on this project . How smartly we have used the loops and IF Conditions and clicking on elements.
In this project you shall see how to fully control the website elements like drop downs or a tags from excel lists which are written on sheets.
How so far work done is going to be noted in excel sheet marking status as Done so next time when code runs it avoids previous already done codes.

Who this course is for:

If you like to be a pro or champion in webscraping using chrome browser then please take this course.
If you have already seen Part1 , then time to learn more advance things in this Part2