Selenium automation using Excel VBA - Selenium-VBA

Selenium-VBA provides a wrapper to bind selenium 1 and Selenium 2 with VBA in excel. That means, you can automate webdrivers using excel macros. It provide support over firefox, chrome, internet explorer and PhantomJS.

And the best part is it's addon that provides script in macro format when you record it using Selenium IDE.

Key benefits include:.

1. Automation of repetitive tasks on web browser.

2. Filling web forms with data in Excel.

3. Extract data from a websites .

4. Extended support to selenium framework within QTP

5. To compare rendering of web pages for regression.

6. Performance measurement in terms of page loading time as well as the server response time.

[sinhaanip]

Great post mate !!! Exactly what I was looking for. Thanks.

[doganyasar]

Can you tell us (@ 2:50) what add on to convert the selenium IDE records to a VB format?

[kailashsoni]

Hi sir
How can we send invoice pdf via whatsapp automation
My traget phone no is in cell b7

Before i used ie
But it was not working fine

So using selenium how to send pdf

[cljd]

Hi have you tried using a function as a test case? for example you created a search function? because i'm getting an error it says browser not started.. but in my Public Sub, i started webdriver there

Function search()
*** codes here
End Function

[amitbodhwani]

Hi, could you please tell me how to add SeleniumWrapper type library in references.
I am using Microsoft Excel 2010 and I could not see this library present in References.
I tried a lot searching for the solution on google but didn't got success till now.
Any little help will be appreciated.
Thanks!

[Athibanbalaji]

My browser closes in a few seconds but my code runs. What to do to stop it from closing???

[dipanshugupta]

Can't see the export to VBA in selenium ide. Can you help me with this?

[carlaortiz]

existe algun objeto no use IE y que pueda insertar el buscador en un formulario para que se pueda ver desde ahí?

[jamespruett]

how can i log into a site manually and then scrape? Is that possible? Thanks for posting!

[wpmorel]

Does this share the browser installation with a Python gecko based install? The firefox browser starts up but doesnt connect in time. Error : Firefox failed to open the listening port 127.0.0.1.59421 within 15s

[AnujGupta-hfif]

Please add your Second channel where you are teaching Selenium so that I can visit your Selenium channel

[thiagoalan]

Very good explanation in this video
Thanks a lot guy!!

[gilsonmiranda]

Sub test()
Dim driver As New selenium.WebDriver
driver.Get "/"
driver.Quit
End Sub

[Jshown]

HELLO Extreme Automation! Do you know how to find hidden elements? thank you

[SanjeevKumar]

Is it possible for existing open browser?

[pragneshparmar]

unable to do and getting error as " user defined type no defined"

[rishabhrajshetty]

Everytime I try to open chrome using selenium vba, I get a popup saying 'Disable Developer extension' and the my code stops working, how can I fix this?

[codixian]

i dont have selenium in my excel library, how to add?

[tufailunnabi]

hey i just did what you said but chrome shuts automatically after few seconds. Fix will be helpful if you provide

[coborela]

Dear
Thanks for your video. nice work.
I have a question. how can I get some data from a website into excel sheet.
I am trying to get an option values from a online shop to a excel sheet so that I can work on it.
could you please give me a direction?
many thanks