The PETRAS timesheet add-in has not been changed for this chapter.
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 Chapter 10
Module
Procedure
Change
FProgressBar (new form)
Added the FProgressBar form shown in Figure 10-11
MSystemCode
ConsolidateWorkbooks
Modified to use the FProgressBar form instead of writing the progress to the status bar