Automate Chrome from Excel VBA using Selenium

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