View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Web Query? Is This Possible?

I am wondering how easy, or difficult, it will be to do a web query on this
site:
http://www.dsireusa.org/

Im not sure if there is a pattern or not; doesnt really seem to be one and
that may prevent this project from getting off the ground. Anyway, I wanted
to try to get Excel to €˜drill down to each state, such as CA, where you
would see this:
http://www.dsireusa.org/incentives/i...srp=1&state=CA

Then drill down to each link, between €˜Financial Incentives and €˜Related
Programs & Initiatives (but not below this). In each of those links I want
to Import .WebTables = "6,7,8", offset 2 or 3 rows and then back out of the
page, drill down to the next link, and so on and so forth. This may be a
massive undertaking, and simply not worth the effort, or it may not be bad at
all. I cant tell, but if someone could assess, and even give me an idea of
how to get started, Id be very appreciative.

Thank in advance!
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.