You're grabbing the data before the page is fully loaded. You need to wait for readystate.
https://learn.microsoft.com/en-us/previous-versions/windows/desktop/ms753702(v=vs.85)
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
This is the snippet of VBA code that I am using to capture the result of a Google search.
With CreateObject("Microsoft.XMLHTTP") 'this will return the complete colletion of characters
.Open "GET", This_Search_String_URL, False
.Send
This_Search_Result_String = .responseText
End With
In the past, it always returned the complete page source string.
It's not working for me now?
Regards
Alfred
You're grabbing the data before the page is fully loaded. You need to wait for readystate.
https://learn.microsoft.com/en-us/previous-versions/windows/desktop/ms753702(v=vs.85)
Great
Thanks for the insight!
Thank you, that is a big help!
I have an Excel/VBA project that passes a collection of search strings to Google and then aggregates the unique results.
The process just died recently and I did not know what was wrong.
Best Regards
Alfred
by the way, the link you posted does not work?
So what do I need to do to ensure that the query has reached a ready state?
Sorry
The link address in the email that I received works!
https://learn.microsoft.com/en-us/previous-versions/windows/desktop/ms753702(v=vs.85)
but the link in on the Docs site did not work?
Alfred