Publishing Data to a Web Page

This chapter has highlighted many ways to capture data from the Web. It is also very useful for publishing Excel data back to the Web.

In Chapter 13, "Excel Power," a macro was able to produce reports for each region in a company. Rather than printing and faxing the report, it would be cool to save the Excel file as HTML and post the results on a company intranet so that the regional manager could instantly access the latest version of the report.

Consider a report like the one shown in Figure 14.9. Using the Excel user interface, it is easy to use File, Save as Web Page to create an HTML view of the data.

Figure 14.9

A macro from Chapter 13 was used to automatically generate this Excel workbook. Rather than email the report,we could save it as a Web page and post it on the company intranet.

0 0

Post a comment