2020spencer
New Member
- Joined
- Apr 18, 2020
- Messages
- 4
- Office Version
- 2007
- Platform
- Windows
Here is my code to operate , try to extract data from a public webpage but I cannot move the slide bar to obtain moew data at once.....
What is coding for control via VBA to webpage slide bar? Thanks
Dim i As Integer
Dim doc, hcol, text As Variant
Dim currentInnerHtml As String
Dim objIE As Object
Set ie = CreateObject("internetexplorer.application")
ie.navigate "恒生指數期貨及期權"
ie.Visible = True
Do While ie.Busy
Application.Wait DateAdd("s", 5, Now)
Loop
Set idoc = ie.document.getElementsByTagName("input")
For Each idoc In idoc
If idoc.getAttribute("loadmore") = "load" Then
idoc.Click
idoc.Click
Exit For
End If
What is coding for control via VBA to webpage slide bar? Thanks
Dim i As Integer
Dim doc, hcol, text As Variant
Dim currentInnerHtml As String
Dim objIE As Object
Set ie = CreateObject("internetexplorer.application")
ie.navigate "恒生指數期貨及期權"
ie.Visible = True
Do While ie.Busy
Application.Wait DateAdd("s", 5, Now)
Loop
Set idoc = ie.document.getElementsByTagName("input")
For Each idoc In idoc
If idoc.getAttribute("loadmore") = "load" Then
idoc.Click
idoc.Click
Exit For
End If