Referencing the Microsoft Office Web Components Object Library

The next several sections of this chapter demonstrate event procedures for PivotTable and PivotChart views. To successfully work with these events, follow the steps below to add a reference to the Microsoft Office Web Components 11 Object Library:

1. In the Acc2003_Chap24 Database window, choose Tools | Macro | Visual Basic Editor.

2. In the Visual Basic Editor window, choose Tools | References.

3. Click the Browse button and locate the following file:

C:\Program Files\Common Files\Microsoft Shared\WebComponents\ 11\OWC11.DLL

4. Click the OWC11.DLL file and then click Open. A reference to Microsoft Office Web Components 11.0 should appear in the Available References list.

5. Click OK to close the References dialog box.

After you add a reference to the Microsoft Office Web Components Object Library, you can use the Object Browser to view the properties, methods, events, and constants for each class of a web component. To see the available classes of a web component, select OWC11 in the Project/Library box in the Object Browser.

0 0

Post a comment