Databases Reference
In-Depth Information
The [Results] area contains a list of the samples and the maximum value of the measurements
taken for that sample (which will always be the last measurement acquired for a sample). In this
particular report, there are only 10 samples, but suppose a report could contain any number of
samples up to a certain maximum. Reports such as this are routinely generated in industry, and
knowing how to navigate through such a Worksheet to obtain the information required for an
analysis is critical for the construction of useful macros.
As an example, a macro to accomplish the following will be constructed. Suppose the appli-
cation requires the [Results] section of the report to be enhanced. Perhaps it would be desirable
not only to have the maximum measurement listed for each sample but also the number of
measurements, the molecular weight, and the plate position (Row and Column) for each sample
to be listed in the [Results] section of the report. The extraction example will demonstrate how to
accomplish all of these.
At first, it might seem that constructing a routine to accomplish these tasks would be a major
undertaking, but, in reality, nearly all the code to accomplish this task has already been written in
both this section and the previous chapters. The correct way to attack data extraction and placement
problems such as this is to first determine the “landmarks” that will be present in the data files
(Figure 3.12). Landmarks are text or numerical references that will always be present within a
FIGURE 3.12
Landmarks in the sample data file.
