Hi,
Is it possible to delay getting the response or somehow waiting for the target website to fetch as well? I'm asking because immediately fetching will basically return nothing since the targeted page is also fetching data.
It can clearly be observed by simply going on their website: https://flyinghead.github.io/flycast-builds/
If you go on it, you will notice it's also fetching info. I can only imagine that's why when I use the code below it's not working since doesn't wait for the data to be fetched on the other end...
library MICROSOFT XML, V6.0 & HTML OBJECT LIBRARY
Dim html As HTMLDocument, xmlhttp As Object, i As Long, list1 As Object
Set xmlhttp = New MSXML2.XMLHTTP60
Set html = New HTMLDocument
With xmlhttp
.Open "GET", "https://flyinghead.github.io/flycast-builds/", False
.setRequestHeader "User-Agent", "Mozilla/5.0 (Windows NT 10.0; WOW64) Chrome/39.0.2171.71"
.Send
html.body.innerHTML = .responseText
Debug.Print html.body.innerHTML
End With
Set list1 = html.querySelectorAll("a")
For i = 0 To 50
With ActiveSheet
.Cells(1, i ) = list1.item(i).innerText
.Cells(1, i+1 ) = list1.item(i).href
End With
Next
Thanks for your time!
Bookmarks