Practical Examples

PETRAS Timesheet

The PETRAS timesheet add-in has not been changed for this chapter.

PETRAS Reporting

At this stage of the PETRAS reporting application, it would be artificial to add a suite of userforms just to demonstrate the techniques discussed in this chapter. Therefore, the only change made to the reporting application for this chapter is to display a progress bar while consolidating all the timesheet workbooks. When we modify the application to use a database back end in Chapter 13 Programming with Databases, we will add a set of userforms to the reporting application for the user to maintain the static lists of consultants, clients, projects and so on. The code changes required to add the progress bar are detailed in Table 10-1.

Table 10-1. Changes to the PETRAS Reporting Application for Chapt r 10

Module	Procedure	Change
FProgressBar (new foro)		Added the FProgressBar formeshown in Figure 10-11
MSystemCode	ConsolidateWorkbooks	Modified to use the FProgressBar form instead of writing the progress to the status bar