如何将Selenium添加到Excel VBA 2013? [英] How can I add Selenium to Excel VBA 2013?

问题描述

我想开发一个与浏览器交互的Excel VBA项目.我听说Selenium是一个很棒的工具，但是在我工作的Excel 2013中，似乎没有在VBA编辑器的Tools> References ...下将它列为对象库.

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.

是否有一个网站可以下载Selenium for Excel VBA并通过浏览"按钮将其导入，或者我注定要放弃此项目?在网上查看后，我可以找到几种编程语言的硒下载，但VBA却找不到.

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.

或者，我还有其他方法可以用来在Excel的Chrome浏览器中读取用户活动标签的URL吗?这里的计算机已被完全锁定，因此我无法像往常一样为它们编写chrome扩展程序，因此我正在寻找解决方法！

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!

非常感谢！

推荐答案

，您可以安装add in，然后在Excel> Tools> reference中启用Selenium wrapper选项，然后就可以继续进行活动了.访问 Selenium Add for excel 下载文件

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

这篇关于如何将Selenium添加到Excel VBA 2013?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！