|
Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word 
Host your Web site with PureHost! 
|
 
Friday, March 13, 2009 – Permalink – Web QueriesDo You Question the Web?This feature can make data acquisition a lot easier than Copy-Paste-Reformat-Try again. "Generally, though, people tend to overlook the option of using the Web as a data source for Excel, be that source the Internet, an intranet, an extranet, or a Web Service. But they shouldn't. Web queries are an easy, yet remarkably flexible and predictable way of bringing data into Microsoft Excel from anywhere on the Web. You can point a Web query at any HTML document that resides on any Web server - or even on a file server, for that matter - and pull part or all of the contents back into your spreadsheet...When you start using Excel's Web queries, you will realize they are almost as limitless as the Web is. Well Kept Secret On the menu bar, go to Data>Import External Data. (In 2007, Data>Get Extrnal Data>From Web). Then, select Import Data to use an existing Web query or select New Web Query to build a new one.  Also see: Vertex42.com: Excel Web Query Secrets Revealed MSDN.Microsoft.com/library Integrate Far-Flung Data into Your Spreadsheets with the Help of Web Services Updating Excel From the Web And: Web Queries and Dynamic Chart Data in Excel 2002 See all Topics excel <Doug Klippert@ 3:49 AM
Comments:
Post a Comment
|
