Extract product price and picture from Amazon

[rohitrajsbl]

Hi evertyone I am new on access vba and learning. My question is, I want to extract amazon "product price" and "product image" into Ms-Access form. So far I am only able to search the product into amazon. here is my code.

Dim IE As Object, obj As Object
Dim myState As String
Dim r As Integer, c As Integer, t As Integer
Dim elemCollection As Object
Set IE = CreateObject("InternetExplorer.Application")
myState = InputBox("What you Want to Seacrh")

IE.Visible = True
IE.Navigate ("amazon.com")
While IE.ReadyState <> 4
DoEvents
Wend

:banghead:

 

[The_Doc_Man]

Re: how to extract product price and product picture from amazon in to Access

First, welcome to the forum.

Second, don't be surprised if one of the moderators moves your post to some other location. I can't do that for you because I'm not a moderator.

Third, search this forum because I recall some discussions on the subject of manipulating web text as input. The search function is in the thin ribbon near the top of the page, the one that has "User CP" on the left. It has "Search" 3rd from the right.

 

[isladogs]

Thread moved to Modules & VBA section as suggested by the Doc Man.