|
Sub d()
Dim dmt As HTMLDocument
Dim htMent As HTMLCommentElement ' As IHTMLElementCollection
Dim i As Integer
Dim Quote As IHTMLElement
webs = Sheets("网址").Range("a1")
WebBrowser1.Navigate webs
Set dmt = WebBrowser1.Document
Application.ScreenUpdating = False
On Error Resume Next
For i = 0 To dmt.all.Length - 1
Set htMent = dmt.all(i)
Vcels htMent, i
Next i
End Sub
-----------------------------------------------------------------
Sub Vcels(htMent As HTMLCommentElement, i)
On Error Resume Next
With Sheets("分析")
.Cells(i + 2, "A") = htMent.tagName
.Cells(i + 2, "B") = TypeName(htMent)
.Cells(i + 2, "C") = htMent.ID
.Cells(i + 2, "D") = htMent.Name
.Cells(i + 2, "E") = htMent.Value
.Cells(i + 2, "F") = htMent.Text
.Cells(i + 2, "G") = htMent.innerText
.Cells(i + 2, "H") = htMent.outerText
.Cells(i + 2, "I") = htMent.nameProp
.Cells(i + 2, "J") = htMent.tagUrn
.Cells(i + 2, "K") = htMent.sourceIndex
.Cells(i + 2, "L") = htMent.href
End With
End Sub
--------------------------------------------------------------------
Sub 清空数据_Click()
Sheets("分析").[a2:aa10000] = Empty
End Sub
-----------------------------------------------------------
Sub 全部分析_Click()
d
Application.ScreenUpdating = False
End Sub
想简化一下功能学习,改代码测试时,为什么说Sub Vcels(htMent As HTMLCommentElement, i)编译错误,用户类型未定义呢 |
|