Automate Chrome from Excel VBA using Selenium
1 views
·
Dec 12, 2021
Learn how to Install Selenium in Windows PC & initiate Chrome browser using Chromedriver.exe from Excel VBA Macro.
From Excel, you can learn to open a Chrome browser and navigate to any website.
How to Automate Chrome browser with Excel - VBA & Selenium?
# ------------ In Detail ------------- #
1. Download & Install SeleniumBasic
https://github.com/florentbr/SeleniumBasic/releases
2. Check version of your Google Chrome Browser
-- Sample: Version 91.0.4472.77 - Official Build 64-bit
3. Download Chromedriver compatible with above version of Chrome
https://sites.google.com/a/chromium.org/chromedriver/downloads
4. Extract Chromedriver.exe from Zip file downloaded from above path & Replace the chromedriver.exe in below path.
C:\Users\%username%\AppData\Local\SeleniumBasic
5. Include reference to Selenium in Excel VBA editor.
Tools - References - Selenium Type Library
6. Try this test program:
Sub InitBrowser()
Dim oChrome As New Chromedriver
oChrome.SetProfile "C:\Users\" & getUserName & "\AppData\Local\Google\Chrome\User Data\Default"
oChrome.Start "chrome", ";https://www.google.com"
oChrome.Get "/"
End Sub
Show More
Show LessComments
loading text loading
loading text loading
loading text
loading text loading
loading text
loading text loading
loading text
loading text loading
loading text