ie Object in VBA

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

http://www.professionisti.bticino.it/web/catalog/online/articledetails.do?articleId=IT_BTI_ARTC1000000761

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 "http://www.professionisti.bticino.it/web/catalog/online/articledetails.do?articleId=IT_BTI_ARTC1000000761"
.Visible = 1
End With
 
'wait a while until IE as finished to load
Do While ie.busy
DoEvents
Loop
 
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?? ***
Next

Open in new window

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

Open in new window

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