How to install Selenium and SeleniumWrapper software for use with Excel VBA.
Steps to install Selenium and SeleniumWrapper software:
(1) Uninstall Any Previous Installation of Selenium
(2) Check Your Chrome Version
Go to Help
About Google Chrome
You would see something like that Version 96.0.4664.45 (Official Build) (64-bit)
(3) Download the Latest Version of Selenium
(4) Download the ChromeDriver
Make sure of the version that suits your chrome version.
For example for my version 96.0.4664.45 (Official Build) (64-bit)
The suitable ChromeDriver is:
chromedriver_win32.zip 2021-11-16 09:36:00 5.80MB b1c93546ea5f304a9e7ac8b3944af7d
(5) Install SeleniumBasic
(6) Next Unzip the chromedriver file chromedriver_win32.zip
Copy the chromedriver.exe to the path of Selenium
Path: C:\Users\%username%\AppData\Local\SeleniumBasic
(7) Test Proper Working of Selenium
Open a new blank Excel file
Press Alt + F11 to Open Visual Basic Editor
Select Tools
Select References
Check box next to Selenium Type Library
Click OK
Run Code Snippet Below
(8) Code Snippet to test Selenium and SeleniumWrapper:
Option Explicit
Dim driver As New WebDriver
Sub Test()
Dim keys As New SeleniumWrapper.keys
driver.Start "chrome"
driver.Get "www.google.com"
driver.Window.Maximize
driver.Wait 1000
driver.SendKeys ("Today's financial news")
driver.Wait 1000
driver.SendKeys (Keys.Enter)
End Sub
(9) Download SeleniumWrapper Software
(10) Learn about use of SeleniumWrapper Software