VBA Selenium Web Scraping Part 1/2

✓ Welcome in Part1 of this VBA Selenium course. Please note what we are covering in this part1
✓ How to use Selenium library inside Excel VBA Editor to scrape websites which supports major browsers like chrome, mozilla, firefox , edge etc.
✓ We are using chrome browser in this series to scrape website elements but you will know how to use other browsers as well.
✓ How to download selenium library and what is the procedure to download browser webdrivers
✓ How to navigate websites using chrome browsers
✓ Learn how to use attributes ID & name or classes to enter a value in search box or text boxes.
✓ Which attribute should you use and why. How to use find function on website for manual search and why it is important to be familiar with this method.
✓ How to click the buttons using attributes like id, name , classname
✓ How to work with tags like A tags and their attribute href.
✓ Also, learn how to use html in notepad and create webpages. It will help you in visualizing the things.
✓ Know how tables are designed on websites and how we can export every table in one go. Know table tags
✓ Know table rows tags and how to work with every or one specific rows and export whatever you need.
✓ Know table headers and table data tags like th and td. Learn how to locate specific td tag
✓ What are collection loops used to scrape tables OR how to scrape one specific table only.
✓ What if user wants to see data for few clients only out of 1000s rows. How to control these tables from excel where user enters the names.
✓ What is the fundamental difference between web element and its collection elements.
✓ Why and where we need SET Keyword and where to avoid it. Proper explanation given.
✓ Using send keys and enter if search button is unable to search data for you.
✓ How to use Header or Rows count property in code to handle them together. Its an amazing approach.
✓ How to use Xpath to enter keywords in input boxes and how we can click on search buttons using xpath
✓ How to read Xpath DOM structure, A proper explanation is given.
✓ How to use Xpath to scrape tables.
✓ How to work with tags like headers – H1,H2,H3 on individual levels and using Xpath method and its benefits.
✓ How to understand VBA Errors if they pop up on screen instead going on google.
✓ How to work with listbox with single property or multiple property.
✓ How to work with drop down using index, text and values property.
✓ Your questions and projects also discussed. Go inside one page drop down and then inside second one.