How to Install Selenium Software

preview_player
Показать описание
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:
(5) Install SeleniumBasic
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()
driver.Start "chrome"
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
Рекомендации по теме
Комментарии
Автор

this video is a thing of beauty, thank you for teaching and sharing

danielsquillante
Автор

Thank you very much for this Sir. You really are a Genius! 👏👏👏👏👏

victoroscar
Автор

Sir, my data has multiple rows, then I how will autofill that data

DK-rwxy
Автор

why code give error { Compile error, user defined type not defined for the following line Dim keys As New SeleniumWrapper.keys

prodcraftsman
Автор

on line "drive.start chrome" it gets stuck, shows running but nothing is opening, I have to kill the excel to stop... Pls help Sir.

shyammogal
Автор

I'm getting "Compile error, user defined type not defined for the following line Dim keys As New SeleniumWrapper.keys" when I try to run the code. Please help.

jeffbartuch
Автор

Hi sir can i know why i am getting error 7 out of memory problem?

ryanngxiangning
Автор

We all know VBA code security is very weak. There are ways to secure the VBA code which is totally unbreakable?

mmbcampus
Автор

When you said "Go to help" it sounded to me as if you said "Go to hell" 😂😂😂 you make very nice content sir tkanks

abidalica
Автор

Latest version is 4.0, sir please make a video to automatically save a webpage as pdf in a particular folder with particular name

floraartworks
Автор

Why Selenium is not working in Office 365 ?

sidharthpattanayak
Автор

Sir your video fake because your selenium install in user /appdat then why show in programme file

ShivKumar-edce