VBA Selenium Web Scraping Part 2/2
Automate Website pages Using Selenium VBA -Google Chrome
Ratings 4.34 / 5.00
What You Will 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.
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 Should Attend!
- 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
