Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Option Explicit
- Sub AMAZONMAIN()
- Dim img As MSHTML.IHTMLElement
- Dim req As New MSXML2.XMLHTTP60
- Dim doc As New MSHTML.HTMLDocument
- Dim linkList As Range, r As Range
- Dim link As String
- Set linkList = Sheet1.Range("A3", Range("A3").End(xlDown))
- For Each r In linkList
- link = r.Value
- req.Open "GET", link, True
- req.send
- Do While req.readyState <> 4
- DoEvents
- Loop
- Dim resp
- resp = req.responseText
- doc.body.innerHTML = resp
- ' Debug.Print Req.responseText
- On Error Resume Next
- r.Offset(0, 1).Value = doc.getElementById("productTitle").innerText
- r.Offset(0, 2).Value = doc.getElementById("feature-bullets").innerText
- r.Offset(0, 3).Value = doc.getElementById("productDescription").innerText '
- r.Offset(0, 4).Value = doc.getElementById("priceblock_ourprice").innerText
- r.Offset(0, 5).Value = doc.getElementById("ourprice_shippingmessage").innerText
- r.Offset(0, 6).Value = doc.getElementById("SalesRank").innerText
- Dim a
- a = Split(resp, """hiRes"":""https")
- Dim i
- For i = 1 To UBound(a)
- r.Offset(0, 6 + i).Value = "https" & Split(a(i), """", 2)(0)
- Next
- Next r
- MsgBox "DATA FETCHED SUCCESSFULL BOSS"
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement