Data Query - How to Change Drop down Selection from Website

Hello,

I am trying to gather stock data information. When it comes to stock prices, websites always show them in batches of 30 days, 60 days, or some number not big enough. The problem is that if you want to 5 years of data, you will need to write data queries for each of the pages: here is an example of writing 30 queries to capture 5 years of data (30 days per page > 6 pages for one year > 30 pages for 5 years).

I was fortunate to find that Nasdaq's site allows you to view up to 10 years of data all on a single page (http://www.nasdaq.com/symbol/wmt/historical)! This is great, however when you make the selection for 10 years (or 5 years or any other selection), the URL of the page does not change which means I don't know how to factor this change into the VBA. Is there any way for the the VBA to sense the spinner/selection tool, and choose the appropriate selection, and then create the query off of the table that loads?

Thanks so much for your help guys

There's no way the code you have can be used to do what you want.

You'll either need to automate IE or use some other method, perhaps XMLHTTP.