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.
:banghead: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