Dim myUrl As String
Dim answer As String
myUrl = "https://...."
Dim WinHttpReq As Object
Set WinHttpReq = CreateObject("MSXML2.XMLHTTP")
WinHttpReq.Open "GET", myUrl, False
WinHttpReq.setRequestHeader "Content-Type:", "application/json"
WinHttpReq.setRequestHeader "X-API-KEY:", "abcdef........"
WinHttpReq.send
answer = WinHttpReq.responseText