(Solved) – Getting data from Resource Guru


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"


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!

Leave a Reply

Your email address will not be published. Required fields are marked *