The OnConnect event occurs when the PivotTable report connects to its data source. Use this event to perform the required operations once the PivotTable has connected to the data source.

The procedure in Hands-On 24-21 notifies the user that the connection to the data source has been established and displays the SELECT statement that provides the dataset for the PivotTable view.

Note: Microsoft Office Web Components (OWC) is a set of ActiveX controls installed with Microsoft Office 2003. You can find detailed documentation about using and programming these components in the help files (OWCVBA11.CHM, OWCDCH11.CHM, OWCDPL11.CHM) installed on your computer's system drive in the following folder:

\Program Files\Common Files\Microsoft Shared\Web Components\11\1033

Part IV

0 0

Post a comment