responsetext

Trying my hand at web-scraping again. I want to grab a specific text from a website, and to do so the first part of my code dumps the website's response into a cell of the worksheet. Here is the code: Sub Test() Dim URL As String Dim HTTPObject, HTMLObject As Object URL =...

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...

I'm using XMLHTTP to grab the source from various pages so that I can extract links and information from them. I've encountered a case where the information I need is buried inside the head block of the page, inside a script tag. When I examine the string loaded into the xmlhttp's...