The two Web query samples in this folder are designed to illustrate how you can use Web queries to work with data retrieved from a Web page. WebQuerySample.xls: This sample contains a mortgage rate calculator you can use to calculate mortgage payments on loans. The mortgage calculator is linked to data on the MortgageRates worksheet. When the workbook is opened, VBA code executes a Web query that populates the MortgageRates sheet with current data on mortgage rates for a variety of loan types. When you select a loan type from the combo box on this sheet, the current interest rate data returned by the Web query is used to calculate the payment amount. WebQueryTableFinder.xls: In Excel 2000, you can now specify a specific table on a Web page as the data source for a Web query. You do this using the New Web Query dialog box. You can open this dialog box by clicking Get External Data on the Data menu and then clicking New Web Query. One of the options in the New Web Query dialog box allows you to return a specific table of data from a specified Web page. However, it is up to you to figure out the number that represents the table you want to use. Unless you know a lot about HTML, this can sometimes be hard to determine. This sample application makes it simple. Run the OpenTableFinderDialog macro and navigate to a Web page that contains the data you want to use. After you click the View Tables button, you can browse through each table on the page until you locate the one you want to use as a data source. To create a Web query that uses that table as its data source, click the Get Table button.