Some folks at Microsoft Research have developed an add in that makes it easy to use a Web page as a data source in Excel. Here is a brief description:The Excel 2007 Web Data Add-In provides an intuitive user interface for importing textual data from any given webpage via a user’s selections of interest,
Office 2007 Standard Key, such as stock quotes,
Windows 7 X64, weather temperature, ect,
Office 2010 Download, into a spreadsheet and keeping that data “up-to-date”. That is,
Office Enterprise 2007, if the webpage data changes,
Microsoft Office 2007 Enterprise, the spreadsheet can be updated by a click of the data “Refresh” button. Also note that the add-in can automatically learn from a user’s selection and optionally select similar items to help save time. Please note that this add-in is a research beta and is unsupported by Microsoft. Feedback and bugs can be sent via the add-in itself (under the it’s help menu) or the add-in’s blog comments. The add-in is available here. Please feel free to give the Research team feedback.