Extract Data From A Webpage?Mar 1, 2011
I have the following code to open a webpage:
Dim IE As Object
Dim x As Integer
Dim c As Variant
The page that opens is in xml and in that xml there is the "page_count" that I need to pick out so I can tell my macro when to stop looping. I have dimmed it as "c" in the code above. Following is the XML.
Somehow I need c = "4", which is the "page_count". Does anyone know how I can pick out the "4" from the xml on my page?