vba访问内嵌框架
如题,vba访问内嵌框架,获得网页文档
--------------------编程问答--------------------
Sub 比如说()
On Error Resume Next
With CreateObject("internetexplorer.application")
.Visible = True
.Navigate "http://bbs.csdn.net/topics/390501860"
Do Until .ReadyState = 4
DoEvents
Loop
Debug.Print .document.frames(4).document.body.innerText
End With
End Sub
--------------------编程问答--------------------
Sub 或者说()
On Error Resume Next
With CreateObject("internetexplorer.application")
.Visible = True
.Navigate "http://bbs.csdn.net/topics/390501860"
Do Until .ReadyState = 4
DoEvents
Loop
Debug.Print .document.frames("frm_tt1").document.body.innerText
End With
End Sub
--------------------编程问答--------------------
Sub 再或者说()
With CreateObject("internetexplorer.application")
.Visible = True
.Navigate "http://sh.189.cn/"
Do Until .ReadyState = 4
DoEvents
Loop
.document.frames("rechargeOrLogin").frames(0).document.body.All.tags("a")(0).Click
End With
End Sub
补充:VB , VBA