Partager via


_QueryTable.Recordset Property

Returns or sets a Recordset object that’s used as the data source for the specified query table or PivotTable cache. Read/write.

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

Syntax

'Declaration
Property Recordset As Object
    Get
    Set
'Usage
Dim instance As _QueryTable
Dim value As Object

value = instance.Recordset

instance.Recordset = value
Object Recordset { get; set; }

Property Value

Type: System.Object

Remarks

If this property is used to overwrite an existing recordset, the change takes effect when the Refresh method is run.

See Also

Reference

_QueryTable Interface

_QueryTable Members

Microsoft.Office.Interop.Excel Namespace