Selenium automation using Excel VBA - Selenium-VBA

Share
Embed
  • Published on Nov 25, 2014
  • 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.

Comments • 20

  • Thiago Alan
    Thiago Alan 2 years ago +1

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

  • David Luu
    David Luu 11 months ago +1

    FYI, there is also an alternative to Selenium VBA, for those that might have issues with it: htejera.users.sourceforge.net/vbswebdriver/

  • rishabhraj shetty

    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?

    • Srinivas T
      Srinivas T 5 months ago

      replace the chromedriver with the latest version to fix this ( it will be available under "selenium wrapper" folder under Drive C or D )

  • james pruett
    james pruett Year ago

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

  • RAVI ROSHAN
    RAVI ROSHAN 2 years ago +1

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

    • Sandy Happy
      Sandy Happy 4 months ago

      Did you get it in your excel..? i am also not getting...!!!

  • Amit Bodhwani
    Amit Bodhwani 2 years ago

    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!

  • Siem Eikelenboom
    Siem Eikelenboom 2 years ago

    Last week, for some reason (maybe after a Chrome upgrade or a Windows Defender cleanup), the Selenium Wrapper stopped working. It started a Chrome window, but did not display any content.
    We solved this in five steps
    1. download SeleniumBasic-2.0.9.0.exe from github.com/florentbr/SeleniumBasic/releases
    2. run the exe
    3. download chromedriver.exe from chromedriver.storage.googleapis.com/index.html?path=2.25/
    4. copy chromedriver.exe from the zip file to C:\Program Files\SeleniumBasic
    5. remove the Block from the exe file through the properties (not sure if that was necessary)
    Current version of Google Chrome: 54.0.2840.71 m
    We had some problems with Windows Defender detecting chromedriver.exe as an infected file. We disabled Defender during the installation, in the hope Defender was wrong about that.

  • Lakshmi Ramakrishnan
    Lakshmi Ramakrishnan 2 years ago

    Hi Gr8 work
    Could you please help me with the url for your selenium videos? I'm a beginner having thirst to learn selenium.... but good at vba excel macros & UFT ...............

  • Anubhav Sinha
    Anubhav Sinha 3 years ago

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

  • cljd
    cljd 3 years ago

    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

  • Gilson Miranda
    Gilson Miranda 3 years ago

    I´m using windows 8 and office 2013, also the selenium basic 2.0.5.0, but I keep getting the Run-Time Error 429 (support.microsoft.com/en-us/kb/828550) Do you know what´s causin' it? Thanks!
    Sub test()
    Dim driver As New selenium.WebDriver
    driver.Start "chrome", "www.google.com"
    driver.Get "/"
    driver.Quit
    End Sub

  • Nazmus Sakib
    Nazmus Sakib 3 years ago

    +xtremeExcel How do we close the browser using the code? Is there anyway I can do this with browser running behind?

  • Jeff Miller
    Jeff Miller 4 years ago

    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

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher  4 years ago

      +Jeff miller Thank you for writing to us. You can read google documentation :code.google.com/p/selenium-vba/ to learn more. You can also write us at excel.microk@gmail.com to avail our services.
      Regards,
      Extreme Excel Group