Hello,
In short: I am trying to populate tables with values pulled from the internet.
Here is the problematic portion of my code (I apologize for being a noob at formatting on this forum):
************************************************** *
'Open IE
Dim ie As Object
Set ie = CreateObject("internetexplorer.application")
ie.Visible = True
'Navigate and Record Values
With secondary
.MoveFirst
Do While Not .EOF
Manufacturer = .Fields("manufacturer").Value
Model = .Fields("model").Value
amzurl = .Fields("amazon url").Value
neggurl = .Fields("newegg url").Value
ie.navigate amzurl
While ie.busy
DoEvents
Wend
Me.Price.Value = ie.Document.getElementById("priceLarge").Value
Exit Do
Loop
End With
********************************************
I know there are all kinds of problems but my concern is the line "Me.Price.Value = ie.Document.getElementById("priceLarge").Value" because that's where my code gets hung (Runtime Error 91: Object variable or with block variable not set). The page successfully opens and loads but when that line tries to read a value it gives the mentioned error.
I've googled and googled trying to find how to fix this and it's not working. Thank you for your help.