I trying to fetch data from a web page (Resource Guru), which is main of our planing of engineers around the world to excel.
While I’m new to the “getting data from web” I tried some stuff I found on google like :
Dim request As Object Dim response As String Dim html As New HTMLDocument Dim website As String Dim price As Variant 'Define URL website = "https://app.resourceguruapp.com/somestuff/companyname/resources" Set request = CreateObject("MSXML2.XMLHTTP") request.Open "GET", website, False request.setRequestHeader "IF-Modified-since", "Sat, 1 Jan 2000 00:00:00 GMT" request.send response = StrConv(request.responseBody, vbUnicode) MsgBox (response) html.body.innerHTML = response price = html.getElementsByClassName("_2tZlDeCUZ8Ga_4930sUxi7")(0).innerText MsgBox (price)
For easy web pages, those containing fuel prices, the code works well. On the web page I want the data from it returns nothing into the variable “price”. The response is somehow cryptic, I wanted to share a picture but I cant while I’m new to the forum.
My question is:
Am I having a problem with the login to that page?
Am I having trouble with the response in a wrong format?
Am I having a problem with the programming languages?
Thanks for a reply!