WebSelectionType Property

         Example         Applies To

Returns or sets a value that determines whether an entire Web page, all tables on the Web page, or only specific tables on the Web page are imported into a query table. Can be one of the following xlWebSelectionType constants: xlAllTables, xlEntirePage, or xlSpecifiedTables. The default constant is xlAllTables. Read/write xlWebSelectionType.

Remarks

Use this property only when the query table’s QueryType property is set to xlWebQuery and the query returns an HTML document.

If the value of this property is xlSpecifiedTables, you can use the WebTables property to specify the tables to be imported.