Extract product price and picture from Amazon (1 Viewer)

rohitrajsbl

New member
Local time
Yesterday, 19:18
Joined
Nov 14, 2018
Messages
1
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

Immoderate Moderator
Staff member
Local time
Yesterday, 21:18
Joined
Feb 28, 2001
Messages
26,946
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

MVP / VIP
Local time
Today, 02:18
Joined
Jan 14, 2017
Messages
18,164
Thread moved to Modules & VBA section as suggested by the Doc Man.
 

Users who are viewing this thread

Top Bottom