VBA Selenium Web Scraping Part 2/2

Automate Website pages Using Selenium VBA -Google Chrome

VBA Selenium Web Scraping Part 2/2
VBA Selenium Web Scraping Part 2/2

VBA Selenium Web Scraping Part 2/2 udemy course

Automate Website pages Using Selenium VBA -Google Chrome

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