VBA Selenium Web Scraping Part 2/2

Automate Website pages Using Selenium VBA -Google Chrome

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

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

Requirements

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

Target audience

• 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