Just ran across this Excel 2007 Web Data Add-In from MSR – great way to scrap data from a web page – you can easily bring the data into Excel without much effort and then save the excel spreadsheet and refresh the data when you need it.
The Excel 2007 Web Data Add-In makes it easy to use a Web page as a data source in Excel. The add-in plugs into Excel 2007 seamlessly, its entry point located on the Data Tab under the From Web option. The system extracts data by learning from a user’s selection of data they wish to capture into Excel. The more selections, the more the system is trained. An example scenario: You wish to import and track data from MSN’s weather page. Visit the site using the tool, enter Data Capture mode, and select a row or two of data from the table. Then click Select Similar, and the system will find similar data based on your previous selections. You then can click Import and leverage Excel’s rich data-editing capabilities, including the Refresh command, which will revisit the Web page and extract potentially new, updated data.
Cross Posted from Dan Fay’s Blog (http://blogs.msdn.com/dan_fay)