Skip to content

Latest commit

 

History

History
50 lines (28 loc) · 1.15 KB

Excel.workbook.pivottableopenconnection.md

File metadata and controls

50 lines (28 loc) · 1.15 KB
title keywords f1_keywords ms.assetid ms.date ms.localizationpriority
Workbook.PivotTableOpenConnection event (Excel)
vbaxl10.chm503095
vbaxl10.chm503095
b6ce12f7-7bc6-bfcc-33f4-2e8ea6e53bae
05/29/2019
medium

Workbook.PivotTableOpenConnection event (Excel)

Occurs after a PivotTable report opens the connection to its data source.

Syntax

expression.PivotTableOpenConnection (Target)

expression A variable that represents a Workbook object.

Parameters

Name Required/Optional Data type Description
Target Required PivotTable The selected PivotTable report.

Return value

Nothing

Example

This example displays a message stating that the PivotTable report's connection to its source has been opened. This example assumes that you have declared an object of type Workbook with events in a class module.

Private Sub ConnectionApp_PivotTableOpenConnection(ByVal Target As PivotTable) 
 
 MsgBox "The PivotTable connection has been opened." 
 
End Sub

[!includeSupport and feedback]