Description

It makes it possible to automate web browsing using Excel and VBA code or using a simple VBS file executed by double-clicking on it. User's actions can be recorded using the Firefox plugin named "Selenium IDE" and translated to VBA or VBS with the provided formatters.

It comes usefull to:

Automate repetitive web browser tasks.

Quickly fill a web form multiple times with an Excel data set.

Extract data from a web page in an Excel sheet.

Run web tests against an Excel data set (Data-Driven Testing).

Take screenshots of a Web site and save them in a PDF file.

Use the selenium automation framework within QTP (Quick Test Pro).

Compare the rendering of two web pages to quickly detect regressions

Measure the page loading time as well as the server response time.

This project provides:

A COM library to use Selenium with Excel in the Visual Basic Editor or within a visual basic script (VBS).

The Selenium IDE plugin with new formatters to convert recorded actions to the VBA/VBS programming language.

All the Selenium 2 commands

A console application to run scripts

A simple and quick way to drive Firefox, IE, Chrome, Opera and PhantomJS (headless webkit).

Download

Release page Bug tracker

Report an issue Third party software

Selenium - Software Freedom Conservancy
Chrome driver - New BSD License
Opera driver - Creative Commons Attribution 3.0 Unported license
PhantomJs web stack - BSD license

Tested environments

Windows 8.1 / Excel 2010 32-bit / Firefox 39 / Selenium IDE 2.9.0
Windows 7 / Excel 2010 32-bit / Firefox 39 / Selenium IDE 2.9.0
Windows XP / Excel 2003 / Firefox 39 / Selenium IDE 2.9.0

Authors and Contributors

Florent BREHERET