Hacking Excel: Installing Selenium Basic

Selenium Basic is an add-on library for Excel Visual Basic. I am positive there are a lot more uses than I know of, but what I know about it makes it well worth learning. You can use it to build fancy automated robots that interact with web pages/applications.

In order to use it though, you have to go out and get and add it as a reference to your Excel workbook. This simple tutorial will help guide you through that process.

1. Download Selenium Basic

Selenium Basic is freely available on Github. Click the link or paste https://github.com/florentbr/SeleniumBasic/releases in your browser. Find where it says “SeleniumBasic-2.0.9.0.exe” or whatever the newest version is and click it to download.

SeleniumBasic

 

2. Install Selenium Basic

You simply double-click the file you downloaded and follow the screen prompts. You have to accept the license agreement.

When you get to the screen below, stop and make sure to choose the web drivers you want to work with. If in doubt, select it.

SeleniumInstall_chooseWebDrivers

 

3. Create the Excel Reference

Now that you have it installed, you need to let Excel know to use it. This optional reference does not exist without installing Selenium Basic, so you must make sure to install first.

on your developer panel, find “Tools” along the top menu bar. Then in the “Tools” drop-down select “References.”

AddExcelReference

 

You will get the “Reference” dialog box. Within that, scroll down until you find “Selenium Type Library” and place a checkmark in the box next to it. Hit the “OK” button and you are ready to go.

SeleniumReference.png

 

 



Categories: Selenium Basic, Tutorials, VBA

Tags: , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: