+ Reply to Thread
Results 1 to 3 of 3

Pulling data from websites such as amazon using Excel VBA

Hybrid View

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    hong kong
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Pulling data from websites such as amazon using Excel VBA

    Not working obviously but might as well post it for you guys to see what's wrong:

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Row = Range("Search").Row And _
    Target.Column = Range("Search").Column Then
    Dim IE As New InternetExplorer
    IE.Visible = True
    IE.navigate "www.amazon.com/s/?field-keywords=" & Range("Search").Value
    Do
    DoEvents
    Loop Until IE.readyState = READYSTATE_COMPLETE
    Dim Doc As HTMLDocument
    Set Doc = IE.document
    Dim sDD As String
    sDD = Trim(Doc.getElementsByTagName("DIV")(1).getElementsByTagName("DIV")(2).getElementsByTagName("DIV")(0).getElementsByTagName("DIV")(0).getElementsByTagName("DIV")(1).getElementsByTagName("DIV")(3).getElementsByTagName("DIV")(0).getElementsByTagName("DIV")(2).getElementsByTagName("H3")(0).getElementsByTagName("A")(0).innerText)
    MsgBox sDD
    End If
    End Sub

  2. #2
    Registered User
    Join Date
    03-31-2020
    Location
    Toccoa, GA
    MS-Off Ver
    app
    Posts
    1

    Re: Pulling data from websites such as amazon using Excel VBA

    Did you ever find a solution to the amazon thing?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1