Microsoft Office Tutorials and References
In Depth Information
It’s beyond the scope of this topic to document the Web Components, but the following code
can be used to save a workbook as an interactive Web page, where the workbook contains a
range of data to be published in a specified range, a PivotTable, and an embedded chart.
Tip Customize Your Procedure
Keep in mind that to run this procedure you’ll need to customize the PublishInteractivePage
procedure to reference your Web server, the correct filenames, and the worksheet name
you have set up for this example.
Sub PublishInteractivePage()
With ActiveWorkbook.PublishObjects
.Add(xlSourcePivotTable, “http://localhost/page.htm", “Sheet1", _
“PivotTable1", xlHtmlList).Publish True
.Add(xlSourceRange, “http://localhost/page.htm", “Sheet1", _
“A1:C30", xlHtmlCalc).Publish False
.Add(xlSourceChart, “http://localhost/page.htm", “Sheet1", _
“Chart 1", xlHtmlChart).Publish False
End With
End Sub
Tip Expanding Your Web Page
To publish workbook components to individual Web pages, save the individual objects to a
new page.
The resulting Web page is quite simple because only placeholders for the various Web
Components are added. Now that the page has been created and contains the Web Components,
modify this page so that it’s presentation quality.
Microsoft Office Web Components provide the means to make it possible for you to publish
Office documents to the Web while preserving the interactivity the documents have when
they are viewed in their native applications. The Office Web Components are a collection of
ActiveX controls. When Microsoft Office users view a Web page that contains an Office Web
Component, they can interact with the data displayed in that document right in Microsoft
Internet Explorer. Users can sort, filter, add, or change data, expand and collapse detail views,
work with PivotTable lists, and chart the results of their changes. In addition, the Office Web
Components are fully programmable, which makes it possible for you create rich, interactive
content for Web-based applications.
Note Office Web Components only work in Internet Explorer 4.01 or later, and the
Microsoft Access data access pages work only in Internet Explorer 5 or later. In addition,
you get the most complete functionality with all the Office Web Component controls in
Internet Explorer 5 or later.
Search JabSto ::

Custom Search