Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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''. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |