VBA MSXML2.XMLHTTP60 put in array or variable

[michiel_soede]

Hi everybody,

Hopefully there is someone that can help me with the following. Below code will pass the responsetext in a msg box. I need the GUID from that responsetext and put that in a variable. Anybody a suggestion here? I saw a number of threads on passing this to a dictionary but I simply was not able to do so.

Thanks in advance,

Michiel

Sub test()Dim xmlHttp As New MSXML2.XMLHTTP60, myurl As String




myurl = "https://vodafoneziggo.sharepoint.com/teams/project-ifrs16/Lists/Variance%20Cars%20New/AllItems.aspx" '//replace with your URL
xmlHttp.Open "GET", myurl, False
xmlHttp.send
MsgBox (xmlHttp.responseText)




End Sub

 

[Norie]

Michiel

What is actually returned in responseText?

 

[michiel_soede]

I am not sure how to add an image to the forum:

https://drive.google.com/open?id=1dRqpM0JzhxF_xkh3QQwadghZN2bSlNk4