Partager via


_QueryTable.WebSelectionType Property

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. Read/write XlWebSelectionType.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property WebSelectionType As XlWebSelectionType
    Get
    Set
'Usage
Dim instance As _QueryTable
Dim value As XlWebSelectionType

value = instance.WebSelectionType

instance.WebSelectionType = value
XlWebSelectionType WebSelectionType { get; set; }

Property Value

Type: Microsoft.Office.Interop.Excel.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.

See Also

Reference

_QueryTable Interface

_QueryTable Members

Microsoft.Office.Interop.Excel Namespace