Channel: Dinesh Kumar Takyar

Category: Education

Tags: excel vba advanced tutorialfree excel vba examplesdownload vba exampleswhat is vba in exceladvanced excel vbaexcel to vbaexcel vba for beginnersusing selenium with excel vbaexcel vba youtubelearn advanced excel vbahow to install selenium softwareexcel vba beginner tutorialhow to install seleniumwrapper softwareexcel vba helpexcel vba for noobsexcel vba tutorials for beginnersexcel vba tutorialexcel vba for advanced learnersexcel vba easy

Description: 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 "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