Excel Selenium Update ChromeDriver and Link to Open Browser
This video shows how (in Excel VBA) to automate updating of ChromeDriver to match Chrome, and how to link code to an already opened window of Chrome
Code Used
----------------------------------------------------------------
Update ChromeDriver (uses Selenium VBA)
Sub UpDateChromeDriver()
Dim Mngr As SeleniumVBA.WebDriverManager
Set Mngr = New SeleniumVBA.WebDriverManager
Mngr.AlignChromeDriverWithBrowser
''next two lines update chromedrive in SeleniumBasic installation folder
Mngr.DefaultDriverFolder = Mngr.GetSeleniumBasicFolderPath
Mngr.AlignChromeDriverWithBrowser
End Sub
----------------------------------------------------------------
Launch Chrome via command Line
chrome.exe --remote-debugging-port=9300 --user-data-dir=C:/chromeDriver
----------------------------------------------------------------
Connect to open browser - Selenium VBA
Sub Connect_To_Open_Browser_SeleniumVBA()
Dim Bot As SeleniumVBA.WebDriver
Dim Caps As SeleniumVBA.WebCapabilities
Set Bot = New SeleniumVBA.WebDriver
Bot.StartChrome
Set Caps = Bot.CreateCapabilities
Caps.SetDebuggerAddress "127.0.0.1:9300"
Bot.OpenBrowser Caps
Bot.NavigateTo ("https://au.yahoo.com")
End Sub
----------------------------------------------------------------
Connect to open browser - SeleniumBasic
Sub Connect_To_Open_Browser_SeleniumBasic()
Dim Bot As Selenium.ChromeDriver
Set Bot = New Selenium.ChromeDriver
Bot.SetCapability "debuggerAddress", "127.0.0.1:9300"
Bot.Start
Bot.Get "https://au.yahoo.com"
End Sub