PivotCache.SourceConnectionFile Property

Syntax

expression.SourceConnectionFile

expression A variable that represents a PivotCache object.

Example

This example determines if a connection exists for the PivotTable cache and, if there is a connection, displays the file name. If no connection exists, the code handles the run-time error and notifies the user. This example assumes a PivotTable exists on the active worksheet.

Sub CheckSourceConnection() Dim pvtCache As PivotCache Set pvtCache = Application.ActiveWorkbook.PivotCaches.Item(1) On Error GoTo No_Connection MsgBox "The source connection is: " & pvtCache.SourceConnectionFile Exit Sub No_Connection: MsgBox "PivotCache source can not be determined." End Sub

See also:

• PivotCache Object
• PivotCache Object Members