Using Google Chrome in Selenium VBA (Installation Steps) Using Google Chrome in Selenium VBA (Installation Steps) selenium selenium

Using Google Chrome in Selenium VBA (Installation Steps)


excel vba selenium

First of all, go to control panel and uninstall previous installation of selenium and then follow the steps1- Download the latest version of chrome and make sure of the version of Chrome from Help >> About Google Chrome. You would see something like that Version 75.0.3770.142 (Official Build) (32-bit)

2- Download the latest version from the LINK

3- Download the chromedriver from the follwoing LINKMake sure of the version that suits your chrome versionAs for the Google Chrome version I posted the most suitable version of chromedriver is ChromeDriver 75.0.3770.140

  1. Now setup SeleniumBasic >> After setup unzip the chromedriver file chromedriver_win32.zip and copy the chromedriver.exe to the path of seleniumHere's two possibilties: First >> C:\Program Files\SeleniumBasicSecond >> C:\Users\%username%\AppData\Local\SeleniumBasicCopy the chromedriver.exe to the SeleniumBasic path

  2. Open new blank excel file >> Press Alt + F11 (Visual Basic Editor) >> Tools >> References >> Selenium Type Library

  3. Insert new module and paste the following code to test

Sub Test()    Dim bot         As New WebDriver        bot.Start "chrome", "https://www.google.com"    bot.Get "/"    StopEnd Sub
Expand snippet