Professional Excel Development [Electronic resources] : The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® نسخه متنی

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 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