VBA to Query Zillow Website

[dash11]

For the VBA Guru's Out There:

I have a VBA model that used to work properly, but recent changes to the layout of the Zillow.com website have left me needing to update my code. Attached is a workbook that I use to pull in property values for homes. PLEASE HELP!

[AB33]

This code is written by Leith Ross.
As you find out, the site has changed. Your code find not find any data with h1 as there is none. I have tried to find out how to correct it, but I am unable to see on the home page (homes). Where do you put it the search item (Address) on the search box. If you can see where the data are (On the page), I will try to adjust it.

[dash11]

Correct, but I haven't been able to reach him to try and edit what he had started. I've made several edits in an attempt to get it working again, but continuous changes with the sites layout seems to keep me one step behind. As for the layout of the site, when you first go to www.zillow.com, there's a floating search box that says "Enter an address, neighborhood, city or Zip Code. Taking an address from the workbook and inserting it into that search box, will bring you to a screen that has a "Zestimate", which is really all of the information I need. Previously the code included bringing back various other information, such as the number of bedrooms and baths, but the Zestimate is really all that's needed.

[AB33]

The first 4 columns are on now H3. There are no dl and dt
Perhaps you can post on this thread, so as Leith will see the reply.

http://www.excelforum.com/excel-prog...-zip-code.html
If he has not come back to you by the end of tomorrow , I will try to write my own.

[dash11]

I went ahead and replied to the previous thread, and will wait a response.

[AB33]

I know now why Leith is reluctant or keen to update the code. It has consumed my entire day on adjusting and testing it. I am sure, Leith, would have done much better job than I did, as he has a good grasp of the HTML language. The code takes at least an hour to run on 2654 odd rows. I have included a separate code, as your code has lots of other stuff on it. Your code runs auto as the workbook opens up and does throw an error, but I have manually run it and got all the data (I hope the right data).
I will try to improve the code as I learn more about HTML language, but for now, I have given you all I had.

[dash11]

To say that you're an absolute VBA magician, would be a gross understatement. I can't begin to thank you enough, as this has been a missing element to our business for quite some time now. Thank you!!!!!

[lorenzovillacr]

I couldn't get it to work, but the layout of this thing is incredible <3

[Mike MBH]

I couldn't get it to work either, but would like to... has anyone had any luck?

- Mike
(Excel Novice)

[dash11]

Greetings Obi-Wan! I attempted to get an updated report on our Mortgage portfolio, and every entry pulled in states "Not listed with Zillow". I'm guessing the evil emperors at Zillow rearranged some of the objects on their website. If you happen to have a little time that you could spare, would you PLEASE see if it might be something that is an "easy" fix?

[AB33]

Zillow has a free API. You do not need to rely on HTML's content. There is a code with API on this site. Just do a search on this site. The guy who wrote the code has a link to his site. In fact, he has included his free API's on the code. I do not think he is aware of it.

[givanov]

When I select the range (let's say the first 5 properties on the tab) and hit Ctrl+R, I get an ""ERROR: # 80070005 - Access is denied." error message. I'm running Excel 2010 with all updates/patches.

Thank you.

[FDibbins]

When I select the range (let's say the first 5 properties on the tab) and hit Ctrl+R, I get an ""ERROR: # 80070005 - Access is denied." error message. I'm running Excel 2010 with all updates/patches.

Thank you.

As you have already noticed on both other threads that you hijacked, this is not permitted on this forum.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread