Within Excel-VBA Need to introduce some text in a webpage and then click the adjacent button (input button) and capture the result.
It is necessary NOT to use IE controls. The idea is do it using MSHTML.HTMLDocument and associated controls.
Dim XMLRe As New MSXML2.XMLHTTP60
Dim HTMLDo As New MSHTML.HTMLDocument
XMLReq.Open "GET", PageURL, False
HTMLDo.body.innerHTML = XMLReq.responseText
And from there, to identify in input text box, introduce the text and click de input (submit) button
After that, capture the data on the resulting webpage .
This data would properly organized in a excel spreadsheet (no need of help in this part of the work)