Microsoft Office 2000/Visual Basic Programmer's Guide

Creating a PivotTable List Control

You can insert a PivotTable List control in a Web page in several ways:

• In Excel, you add a PivotTable List control to a Web page by creating a list or PivotTable report in Excel and then using the Publish as Web Page dialog box to save the data in a PivotTable List control on a Web page.

  For more information about using the Publish as Web Page dialog box, see "Using Microsoft Excel to Create a Spreadsheet Control" earlier in this chapter. For information about creating and working with PivotTable reports in Excel, see Chapter 15, "Retrieving and Analyzing Data."

• In Access, you can add a PivotTable List control to a data access page by dragging a table or query from the field list to the page. This creates a PivotTable List control populated with data from the table or query in the open database.
  
  
• In FrontPage, you can add an unbound PivotTable List control to a page by pointing to Component on the Insert menu, and then clicking Office PivotTable. To bind the control to data, you use VBScript code in the Web page.
  
  
• In a Web page, you can insert a PivotTable List control by adding an <OBJECT> tag for the control to the page and specifying the control's CLSID as the setting for the CLASSID attribute. You can then use VBA or VBScript code to fill the control programmatically when the page loads.

The CLSID for the PivotTable List control and all the objects and related methods and properties for the control are documented in the Msowcvba.chm Help file, which is located in the C:\Program Files\Microsoft Office\Office\1033 subfolder.

Note   The path to the Msowcvba.chm Help file reflects the language ID folder (1033) for U.S. English language support in Office. The language ID folder below C:\Program Files\Microsoft Office\Office differs for each language.