Error 91: Object variable with block variable not set

[tkull]

This code opens an IE tab and puts the cell value from the sheet to the search bar and then click the go button Can someone please rectify the error it is coming in highlighted line:

Option Explicit
Sub getrent()

Dim ele As Object
Dim i As Long
Dim IE As Object
Dim FindHomes As Object

' Create InternetExplorer Object
Set IE = CreateObject("InternetExplorer.Application")


For i = 3 To 101

' You can uncoment Next line To see form results
IE.Visible = False

' Send the form data To URL As POST binary request
IE.Navigate "http://www.zillow.com/"

' Wait while IE loading...
Do While IE.Busy Or _
IE.readystate <> 4
DoEvents
Loop

Set FindHomes = IE.document.getelementsbyname("Find Homes:")
FindHomes.Item(0).Value = Workbooks("Book1").Sheets("Sheet1").Cell(i,5)--------> will this Cell reference work and the runtime error is also in this line, I think it's because of FindHomes

IE.document.getElementById("GOButton").Click

Next

End Sub

[Norie]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[tkull]

Sorry I am new here. Here it is again

This code opens an IE tab and puts the cell value from the sheet to the search bar and then click the go button Can someone please rectify the error it is coming in highlighted line:

Please Login or Register  to view this content.

[Norie]

No problem, the code tags make it a lot easier to read.

Anyway, the problem is that there are no elements on the page with the name 'Find Home:'.

I think I know what you are trying to find but it must have some other name/id.

Give this a try.

Please Login or Register  to view this content.

[tkull]

Thanks a ton !! but somehow it is not able to open any IE window. It is just running and stopping.

[Norie]

IE is opening, it's just not visible.

That's because the code tells it to hide.

Please Login or Register  to view this content.

If you comment that line, or change False to True you should see an IE window.

[tkull]

Hey its working now, silly me, just had to change ievisible to true. Thanks a ton again