troubleshooting Question

Excel VBA form fill IE

Avatar of RAJESH JOSHI
RAJESH JOSHI asked on
VBAMicrosoft OfficeMicrosoft Excel
5 Comments1 Solution118 ViewsLast Modified:
I am trying the following code.
Sub redfin_test()
'Application.ScreenUpdating = False

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True


IE.Navigate "https://www.redfin.com"
Do While IE.Busy = True Or IE.ReadyState <> 4: DoEvents: Loop
Do While IE.Busy = True Or IE.ReadyState <> 4: DoEvents: Loop
Application.Wait (Now + TimeValue("00:00:1"))

IE.Document.getElementsByClassName("search-input-box")(0).Value = "5606 Trout Creek Pass Dr,CO,80917"
Application.Wait (Now + TimeValue("00:00:4"))
IE.Document.Forms(0).Submit
 Do While IE.Busy = True Or IE.ReadyState <> 4: DoEvents: Loop
 Do While IE.Busy = True Or IE.ReadyState <> 4: DoEvents: Loop
 Application.Wait (Now + TimeValue("00:00:4"))
 'IE.Quit
 'Set IE = Nothing


'Application.ScreenUpdating = True
End Sub

It does not show search result.
Manually I enter same value, it returns the result.
Where is my mistake?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros