VBA硒“未注册类"-80040154 [英] VBA Selenium "class not registered"- 80040154

问题描述

我是一个新手，正在尝试实现硒来选择网站上的按钮.看完本教程之后

1)安装chromedriver是否可以解决问题?

ChromeDriver-适用于Chrome的WebDriver

2)我正在使用Windows 10和chrome，但是该代码旨在供使用不同操作系统的多个用户使用.它适用于chrome上的所有操作系统吗?(我知道每种浏览器都需要不同的驱动程序.)

3)我是否必须选择路径"C:\ Users \ * Username \ AppData \ Local \ SeleniumBasic"?在每台用户PC上手动将ChromeDriver和SeleniumBasic安装到此路径将很麻烦.

4)我想我想通过方式1(使用GUID)以编程方式添加SeleniumBasic参考.如何以编程方式添加参考与确定VBA参考库的文件路径或GUID 为了避免在每个安装中重复引用.

解决方案

1. 下载ChromeDriver或firefox Webdriver.

2. 检查是否与计算机的系统架构匹配:32与32以及64与64.

3. 选择如下所示的网络驱动程序补丁:"C://* user *//folder//folder//folder"

I am a newbie trying to implement selenium to select a button on a website. After watching this tutorial youtube guide

I downloaded SeleniumBasic from Github and added the reference to VBA.

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

At running the macro I get an error message "class not registered 80040154".

1) Will installing chromedriver solve the problem?

ChromeDriver - WebDriver for Chrome

2) I am using windows 10 and chrome but the code is meant to be used by multiple users, using different OS. Will it work for all OS on chrome? (I understand that every browser will need a different driver).

3) Must I choose the path "C:\Users\ *Username\AppData\Local\SeleniumBasic" ? That will be a hassle to manually install the ChromeDriver and SeleniumBasic to this path in every users PC.

4)I guess I would like to add the SeleniumBasic reference programmatically with Way 1 (Using GUID) How to add a reference programmatically with Determine the File Path or GUID to a VBA Reference Library in order to save repeating the referencing in each installation.

解决方案

1. Download ChromeDriver or firefox webdriver.

2. Check if you are matching the system arch of your computer: 32 with 32 and 64 with 64.

3. Select the patch of webdriver like that: "C://*user*//folder//folder//folder"

这篇关于VBA硒“未注册类"-80040154的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！