Secrets of the Office Masters: Combine Data from Several Web Sources in a Custom Page
Do you regularly check several Web pages during the day to gather information? Excel's capability to create live links to Web data might let you combine parts of each Web page into a single worksheet. You can then save the resulting worksheet as a Web page and put all those bits and pieces of data into a single easy-to-update location.
The page shown in Figure 25.26, for example, consists of tables drawn from Yahoo!'s Finance page and the home pages of MSN Investor and Thestreet.com. We added headings to identify each block, hid several columns that contained nonessential information, and formatted the top two blocks as Full HTML.
By saving the resulting worksheet ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
