Microsoft Office Tutorials and References
In Depth Information
.SavePassword = False”
.SaveData = True”
.AdjustColumnWidth = True”
.RefreshPeriod = 0”
.WebSelectionType = xlSpecifiedTables”
.WebFormatting = xlWebFormattingNone”
.WebTables = “2"”
.WebPreFormattedTextToColumns = True”
.WebConsecutiveDelimitersAsOne = True”
.WebSingleBlockTextImport = False”
.WebDisableDateRecognition = False”
.WebDisableRedirections = False”
The .WebTables = 2 line in the preceding example tells Excel that you want the third table
on the page. Literally, this is the third occurrence of a <TABLE> tag in the source HTML for
With Excel, you have the ability to incorporate data that you locate from the Web into your
spreadsheets. It’s not necessary to know how the page was created or how to create a query
file. You can select the data you want, and once the information is imported into the
spreadsheet, you can refresh the data with a single click of the mouse. Alternatively, the data can be
refreshed when the workbook is opened, or at specific time intervals.
You can alternatively create a new Web Query using the Import External Data feature within
Excel. Follow these steps outlined to review how to navigate through the dialog box.
Click Data, Import External Data, and then New Web Query.
Type the Web page URL in the Address text box.
Click the Go button to show the Web page within the New Web Query dialog box.
Notice the arrows that appear on the Web page. The arrows when selected will outline
the entire table to be imported into your worksheet.
Select the table to import. When the table is selected, the arrow changes to a check
mark as displayed in Figure 25-5.
Click the Import button.
Two options are available to place the contents of the Web query. Select Existing
Worksheet if you want to display the data in the active worksheet, or select New
Worksheet if you want the data to be placed in a new sheet.