首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >MSHTML.HTMLElementCollection型失配误差

MSHTML.HTMLElementCollection型失配误差
EN

Stack Overflow用户
提问于 2020-11-12 12:47:27
回答 1查看 114关注 0票数 0

我正在创建一个脚本代码来将数据复制到Excel中。我的代码可以正常工作,直到找到我得到的错误type mismatch元素。

代码语言:javascript
复制
Function Login(ID As String, Pass As String) As Boolean
 Dim objIE As SHDocVw.InternetExplorer
 Dim ieDoc As MSHTML.HTMLDocument
 
 Dim UserID As MSHTML.HTMLInputElement
 Dim passwordID As MSHTML.HTMLInputElement
 Dim loginb As MSHTML.HTMLInputElement
 Dim AllHyperlinks As MSHTML.HTMLElementCollection
 Dim hyper_link As MSHTML.HTMLInputElement
 Dim link As Object
    
 Set objIE = New SHDocVw.InternetExplorer
 objIE.navigate URLstr
 
 Do Until objIE.readyState = READYSTATE_COMPLETE
 Loop
 
 Set ieDoc = objIE.document
 objIE.Visible = True
 
 Application.Wait Now() + #12:00:02 AM#
 Set UserID = ieDoc.all.Item("login/")
 UserID.Value = ID
 Application.Wait Now() + #12:00:02 AM#
 Set passwordID = ieDoc.all.Item("password")
 passwordID.Value = Pass
 Application.Wait Now() + #12:00:01 AM#
 Set loginb = ieDoc.getElementsByClassName("button")(0)
 loginb.Click
 Do Until objIE.readyState = READYSTATE_COMPLETE
 Loop
 Application.Wait Now() + #12:00:02 AM#
  
 Set AllHyperlinks = ieDoc.getElementsByTagName("A") 'here i Got Error
 For Each hyper_link In AllHyperlinks
     If hyper_link.innerText = "search" Then
         hyper_link.Click
         Exit For
     End If
 Next
 
 Set objIE = Nothing
End Function

HTML

代码语言:javascript
复制
<a href="javascript:showSearch(true)" title="Search" class="button" id="button_search">
<img src="images/icon_search.gif" alt="">Search
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2020-11-12 13:54:17

替换代码块:

代码语言:javascript
复制
 Set AllHyperlinks = ieDoc.getElementsByTagName("A") 'here i Got Error
 For Each hyper_link In AllHyperlinks
     If hyper_link.innerText = "search" Then
         hyper_link.Click
         Exit For
     End If
 Next

反对:

代码语言:javascript
复制
ieDoc.getElementByID("button_search").Click
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/64804219

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档