VBA script to pull "ZEstimates" from Zillow.com

[Veradusit]

I have this spreadsheet that is actually working quite well. It uses VB to launch IE and query www.zillow.com to pull in their "z" estimate. I need to alter the script to include two other websites. (www.realestateabc.com and www.cyberhomes.com).

Currently the spreadsheet has two known "fixed value" columns, a street address and a zipcode. the macro populates a "Z" estimate column. and I need it to ALSO populate the other two. Sample attached. try it, it works nicely, I just can't seem to get the other two websites working.

[capoeira503]

By chance, do you have the code to the VB script that does the pulling?

[jgarner0519]

Hello, can someone please provide me the excel VBA syntax to make a call to the Zillow GetSearchresults API and the Zillow GetZestimate API? I can't seem to get my code to pull the ZPID in order to get the home and rental values.

Thanks so much for any help that you can provide.

[arlu1201]

jgarner0519,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

[givanov]

Frankly moderator you're getting on my nerves with your "your post does not comply with...". String search "zillow" on this web site. There're 40 threads of people asking the same question and NOT A SINGLE VBA SOLUTION CURRENTLY WORKS. Why? Maybe partially because instead of allowing people to have a discourse in one place about the same question, you're asking people to ask the same question (and related questions) 30 times. Yeah, time to check out more functional web sites. This is a joke.

[FDibbins]

givanov, I want to point out a few things to you...

1. Arlu is an administrator, not a moderator (perhaps you got confused with the spelling on those big words?)
2. Every forum has it's rules, ours is no exception. When you joined you - like ALL other members here - agreed to abide by those rules, 1 of which is no hijacking other member's threads. If those rules are too onerous for you to comply with, perhaps a different forum/site would be more to your liking?
3. You have responded to a thread that is 7 years old, perhaps you also failed to notice that?