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 • 26

  • Thiago Alan
    Thiago Alan 2 years ago +1

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

  • Edwin Xiao
    Edwin Xiao Month ago

    Hi, I used your exact code, but it cannot launch firefox at all. It launched Chrome, but does not display google.com. Could you tell me if I have missed something. Your website is great, btw.

    Dim driver As SeleniumWrapper.WebDriver
    Set driver = New SeleniumWrapper.WebDriver
    driver.Start "firefox", "www.google.com"
    driver.Open "/"

  • pragnesh parmar
    pragnesh parmar 2 months ago +1

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

  • Will M
    Will M 2 months ago +1

    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

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher  2 months ago

      It has nothing to do with python. But you need to have geckodriver present in PATH variable. So, if you have gecodriver present on your desktop, add that path to PATH environment variable.

  • David Luu
    David Luu Year 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 8 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 2 years 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?

    • yogeshwarpe
      yogeshwarpe 2 months ago

      github.com/florentbr/SeleniumBasic/releases/tag/v2.0.9.0

    • Sandy Happy
      Sandy Happy 7 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 4 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 [email protected] to avail our services.
      Regards,
      Extreme Excel Group