SlicerCache.WorkbookConnection Property
Gets a WorkbookConnection object that represents the data connection used by the specified slicer.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property WorkbookConnection As WorkbookConnection
Get
'Usage
Dim instance As SlicerCache
Dim value As WorkbookConnection
value = instance.WorkbookConnection
WorkbookConnection WorkbookConnection { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.WorkbookConnection
A WorkbookConnection object that represents the data connection used by the specified slicer.
Remarks
Read-only.
The WorkbookConnection property only applies to slicers that are based on external data sources (SlicerCache.SourceType = xlExternal). Attempting to access the WorkbookConnection property for slicers that are connected to PivotTables based on workbook ranges or lists (SlicerCache.SourceType = xlDatabase) generates a run-time error.