masuf.blogg.se

Right-click on a cell in your query results and choose Data Range Properties Options that you have with other external data queries, such as ODBC queries. In addition, you have the same choice of Data Range The options here allow you change how the query interacts Page you're querying appears, click the Options button in the upper-rightĬorner of the window to open the dialog box shown in Figure E. (You can also click Edit Query on the Externalĭata toolbar or choose Data | Import External Data | Edit Query.) When the Web To access Web query properties, right-click on a cell in the query The data is now in your worksheet ( Figure D).Īfter you create a Web query, you can customize it to meet The table you want to use for the query ( Figure The URL to query in the Address area and click the Go button ( Figure B). The first cell in which you want results to appear.ĭata | Import External Data | New Web Query to open the dialog box shown in Figure A. Finally, this Web query doesn't put important This case), so it will be easy to manipulate via a VBA macro, and it has littleĬonfusing information in it. Another advantage is that the URL contains the stock symbol (GOOG, in This is a greatĮxample because the data we're interested in is presented in a plain, tabularįormat. Simple Web query using Yahoo! Finance historical stock prices. To demonstrate the process, we're going to start with a Sample implementation of these techniques. You can download this Excel workbook to see a You to work around some Excel limitations and see how a little VBA code can Then, we'll look at a couple of tricks that allow

We're going to work through a basic example to get a feelįor how Web queries operate. Impossible to create or maintain, such as a worksheet that's used by Nicely in situations where a standard ODBC connection would be difficult or Pulling information from standard HTML pages. Select the ones containing data you want to put into your worksheet, allowingįor dynamic updates from the Web page. It will find any tables on the Web page and let you An Excel Web query allows you to bring data from a Web site