VBA Selenium Web Scraping Part 1/2

WebScraping with VBA Selenium via Google Chrome

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

What Will I Learn?

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

Requirements

• You should have good understanding of VBA for next Loops and good understanding of IF functions.

Target audience

• If you are Business analyst and want to learn how to scrape websites using chrome or other major browsers.
• If you like to export website tables into excel. If you like to click on website links or fill up a form or download the files etc.