Microsoft Office Tutorials and References
In Depth Information
Opening the web page directly
Figure 67-3: Information retrieved from a web query.
Opening the web page directly
Another way to get web page data into a worksheet is to open the URL directly, by using Excel’s
File➜Open command. Just enter the complete URL into the File Name field and click Open.
The results will vary, depending on how the web page is laid out. Most of the time, you’ll get
satisfactory results. In some cases, you’ll retrieve quite a bit of extraneous information. Also, note that the
information is not refreshable. If the data on the web page changes, you’ll need to close the
workbook and use the File➜Open command again.
Search JabSto ::




Custom Search