ie Object in VBA

Hi to everybody,
in VBA I nedd to extract from this page

the URL of the image and the item's description.

I've fumbled with ie Object but I couldn't extract the html I need. Below are the few lines I've put together; I couldn't find a complete documentation about the properties of HTMLDocument.
Thanks for any help
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application") 'Need a reference to Microsoft Internet Controls
With ie
.MenuBar = 1
.Toolbar = 1
.StatusBar = 1
.Navigate ""
.Visible = 1
End With
'wait a while until IE as finished to load
Do While ie.busy
Dim HTMLDoc As HTMLDocument   'Need a reference to Microsoft HTML Object Library
Set HTMLDoc = ie.Document
Dim Elm As IHTMLElement 'Object
For Each Elm In HTMLDoc.all
   Debug.Print Elm.tagName 
' *** And NOW?? ***

Open in new window

Who is Participating?
Don't use the IE object, use XMLHTTP
Function ReadUrl(ByVal sUrl)
    Dim oXMLHttpRequest
    Set oXMLHttpRequest = CreateObject("Microsoft.XMLHTTP") "GET", sUrl, False
    ReadUrl = oXMLHttpRequest.responseText
    Set oXMLHttpRequest = Nothing
End Function

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.