play
Automate Chrome from Excel VBA using Selenium
2K views · Dec 12, 2021
Visit Channel:publisher-humix
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

Comments

Latest Videos
'Video thumbnail for Learn Excel VBA Macro - Quick Lesson - 1 Minute'
1:09
play
Learn Excel VBA Macro - Quick Lesson - 1 Minute
2K views
'Video thumbnail for How to Use Vlookup Function? - 1 Minute Video'
1:08
play
How to Use Vlookup Function? - 1 Minute Video
2K views
'Video thumbnail for 4 Different Methods - How to add Leading Zeroes in Excel to Numbers'
3:48
play
4 Different Methods - How to add Leading Zeroes in Excel to Numbers
535 views
'Video thumbnail for How to run VBA Macro Daily Autiomtically without opening Excel file?'
7:23
play
How to run VBA Macro Daily Autiomtically without opening Excel file?
455 views
'Video thumbnail for Add Timestmp to Youtube Video URL   Jump to specific time'
1:24
play
Add Timestmp to Youtube Video URL Jump to specific time
532 views
'Video thumbnail for How to Run VBA Macro without opening Excel file?'
5:30
play
How to Run VBA Macro without opening Excel file?
376 views
'Video thumbnail for How to play a video in Loop or Repeat mode in Youtube Android?'
0:26
play
How to play a video in Loop or Repeat mode in Youtube Android?
1 views
'Video thumbnail for Whatsapp Version Details - Where to Look?'
0:25
play
Whatsapp Version Details - Where to Look?
1K views
'Video thumbnail for How to make Whtsapp Chat messages automatically disappear for selected contacts?'
0:25
play
How to make Whtsapp Chat messages automatically disappear for selected contacts?
23 views
'Video thumbnail for How to Link a table or dynamic named range to a Dropdown list in Excel'
1:27
play
How to Link a table or dynamic named range to a Dropdown list in Excel
9 views