Hi all,
I'm not sure why I'm getting an "object required" error for the "serh" and "btn" veriables when I set them to ie.getelementId
What I'm having difficulty understanding is that when I run the macro everything runs well until "set serh = ie.getelementId" thats when the debugger kicks in. but I can step through the rest of the macro and it works fine.
Any Ideas on what I'm messing up?
Sub get_quote()
Dim ie As New InternetExplorer
Dim serh As Object
Dim btn As Object
Application.ScreenUpdating = False
ie.Visible = True
ie.Navigate "URL"
While ie.Busy
DoEvents
Wend
Set serh = ie.document.getElementById("UHSearchBox")
serh.Value = Cells(3, 1)
Set btn = ie.document.getElementById("UHSearchProperty")
btn.Click
End Sub
Bookmarks