VBA Selenium Web Scraping Part 2/2

VBA Selenium Web Scraping Part 2/2

• 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.

Automate Website pages Using Selenium VBA -Google Chrome

Url: View Details

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.

Rating: 4.33333

Level: All Levels

Duration: 2.5 hours

Instructor: ajay parmar