CODEWITHSUNDEEP
excelvbainnertextouterhtml
Pedro
Pedro

Reputation: 87

Innertext a specific "src" address using MSXML2.xmlHttp

Using MSXML2.xmlHttp on a specific webpage I’m able with the code bellow debug.print all “SRC” adresses, it brings me 6 “src” adresses. Now I’m trying to innertext into excel - range(“A3”) only the third “src” address. Any help would be nice.

Dim s As String, obj As Object, resp As String

    With CreateObject("HTMLFile")
        .write sResp

        For Each obj In .body.document.getElementsByTagName("img")
            Debug.Print obj.outerHTML
        Next

    End With

Upvotes: 1

Views: 119

Answers (0)

Related Questions