Microsoft Office 2000/Visual Basic Programmer's Guide   

Creating Web Pages to Display Excel Data

To create a Web page to display data from Excel, save all or part of an Excel workbook as HTML. You can create either a static report or a dynamic report on a Web page. The report may also be either read-only or interactive.

For a sample procedure that publishes data from an Excel workbook to a Web page, see the PublichDataToWebPage procedure in modPublish module in the Northwind.xls sample file, available in the ODETools\V9\Samples\OPG\Samples\CH15 subfolder on the Office 2000 Developer CD-ROM. For more information about creating dynamic Web pages, see Chapter 12, "Using Web Technologies."