Using Google Chrome in Selenium VBA (Installation Steps)

by

First of all, go to control panel and uninstall previous installation of selenium and then follow the steps
1- 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 LINK
Make sure of the version that suits your chrome version
As 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 selenium
    Here’s two possibilties: First >> C:\Program Files\SeleniumBasic
    Second >> C:\Users\%username%\AppData\Local\SeleniumBasic
    Copy 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 "https://stackoverflow.com/"
    Stop
End Sub

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Read/Parse text file line by line in VBA
  3. How do I find the last column with data?
  4. Excel VBA: Answer gets “stuck”
  5. How to insert a picture into Excel at a specified cell position with VBA
  6. Save multiple sheets to .pdf
  7. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  8. filter out multiple criteria using excel vba
  9. Excel VBA autofilter all but three
  10. How can I create a calendar input in VBA Excel?
  11. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  12. Parsing an ISO8601 date/time (including TimeZone) in Excel
  13. Getting the actual usedrange
  14. Delete a row in Excel VBA
  15. Concatenate cell data into another data if values matches
  16. Iterating through populated rows
  17. How can I run VBA code each time a cell gets its value changed by a formula?
  18. How to convert 32 bit VBA code into 64 bit VBA code
  19. Loop through each row of a range in Excel
  20. Outputting Excel rows to a series of text files
  21. How to create a range from two ranges in VBA?
  22. XML parse VBA excel (function trip, & MSXML2.DOMDocument)
  23. Vlookup to copy color of a cell
  24. every possible combination of the contents of 2 columns in excel
  25. How to delete rows in Excel based on criteria using VBA?
  26. Macro to export MS Word tables to Excel sheets
  27. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  28. Excel – Using COUNTIF/COUNTIFS across multiple sheets/same column
  29. Delete all data rows from an Excel table (apart from the first)
  30. Excel VBA Run-time Error ‘32809’ – Trying to Understand it

Leave a Comment