Leading the way in Microsoft Office Development

(Data > Get External Data > New Web Query)

(Data > Get External Data > Run Web Query). Browse to your web query file (.iqy). For all the elements in square brackets, parameters are created. You can reference these parameters to worksheet cells. To update your web query change the parameter cells and hit refresh on the External Data toolbar.

You can open a web page directly in Excel. First open your connection to the Internet. (File > Open) type or paste the URL and click open.

Excel does not save blank pages when a workbook is saved as a web page. This is to condense disk space. So if a workbook contains hyperlinks a hyperlink to a blank worksheet in the same workbook when saved as a “Web Page” the hyperlink will be redundant.

Query Files

Query files are text files with an (.iqy) file extension. Once a query has been selected, you are prompted for how you want the incoming data dealt with by Excel. You may be prompted for other information depending on how the query is constructed.

Things to Remember