How can I add Selenium to Excel VBA 2013?

Question

I'd like to develop an Excel VBA project that interacts with the browser. I hear Selenium is a great tool for this but Excel 2013 where I work doesn't seem to have it listed as an object library under Tools > References... in the VBA editor.

Is there a site where I can download Selenium for Excel VBA and import it via the Browse button, or am I doomed to abandon this project? Having looked online, I can find selenium downloads for several programming languages, but not VBA.

Alternately, is there some other method I can use to read the URL of a user's active tab in a Chrome browser with Excel? The computers here are pretty locked down so I can't write a chrome extension for them like I usually would so I'm looking for a workaround!

Many thanks!

I'm using selenium for a while now to get some data from sites opened in Chrome. Here is the excel add-in site: Selenium excel add-in. In the download page you can find samples as well. — Dawid SA Tokyo
– Dawid SA Tokyo, Commented May 27, 2016 at 9:47
Thank you Dawid, but this is an exe file. It cannot be imported as a library into excel and appears to need to be run via installshield, but the computers here won't let me install it so I'm still looking for an .olb, .tlb or .tll file to add Selenium as a reference library to Excel. — Sparks
– Sparks, Commented May 27, 2016 at 10:05
Have you tried to see if these work? github.com/florentbr/SeleniumBasic, htejera.users.sourceforge.net/vbswebdriver — David
– David, Commented May 25, 2018 at 16:42

Ravi Adabala · Accepted Answer · 2016-09-14 11:12:23Z

3

you can install add in and then enable Selenium wrapper option in Excel>Tools>reference and then you can proceed with your activities. Visit Selenium Add in for excel to download the file

answered Sep 14, 2016 at 11:12

Ravi Adabala

837 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

MT1 Over a year ago

This link downloads an installer which is an .EXE file. The web drivers seem OK but it tries to install an IDE for Firefox which fails because it is "corrupt".

MT1 Over a year ago

This works for Excel 365 VBA. Option Explicit //Public Sub sbSeleniumTutorial() //MsgBox "sbSeleniumTutorial()" //Dim bot As New WebDriver //bot.Start "edge", "yahoo.com" //bot.Get "/" //End Sub

Collectives™ on Stack Overflow

How can I add Selenium to Excel VBA 2013?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related