vba html网页自动登录,javascript – 使用VBA在网页中填写用户名和密码

这是我第一次尝试通过VBA导航IE浏览器.

我在尝试着：

– 转到此网页https://hb2.bankleumi.co.il/e/Login.html

– 填写用户名

– 填写密码

– 单击“登录”按钮

现在我收到对象’IWebBrowser2’失败的错误“方法’文档’”

我试图检查网页的html代码中的元素并找到它们的ID,但我想我在调用方法或接近对象时犯了一些错误.

我的代码是：

Option Explicit

Sub dataFromLeumi()

Dim myPassword As String

myPassword = "somepassword"

Dim myUserName As String

myUserName = "someusername"

Dim loginPath As String

loginPath = "https://hb2.bankleumi.co.il/e/Login.html"

Dim IE As Object

Set IE = CreateObject("InternetExplorer.application")

IE.Visible = True

IE.navigate loginPath

Dim userName As Object

Set userName = IE.document.getattribute("uid")

userName.Item(0).Value = myUserName

Dim password As Object

pa