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