VBA Selenium Web Scraping Part 1/2
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.85 GB | Duration: 5h 51m
WebScraping with VBA Selenium via Google Chrome
What you'll 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.
Description
In this Part1 you shall learn below written things. Please go through them.
We are going to learn Webscraping using google chrome and it will be done using selenium library.
Learn how to download selenium and browser drivers to first initially do the setup.
