I retrieve data about local reservoirs (elevation, precipitation, gated release, ...) from a web site (http://www.swf-wc.usace.army.m…/rcshtml.pl?page=Reports). Retrieving the reports requires manipulating three drop boxes ("Select lake", "Year", "Data Type"). After that, I copy the data to the clipboard, and, back in Excel, push a button that pastes the text and extracts the data.
I'd like to programmatically manipulate those controls so that data retrieval can be completely automated. Is that possible?
Thanks in advance for suggestions.