The macros I have written open four files from a database and mostly just
combine and reformat them with some deletions based upon some simple
criteria and it removes duplicates. It also strips out some columns from a
couple of the files.

Then the report gets printed and all the data deleted and it is run again on
another set of four data files. The user may need to run this operation and
print reports for as many as 4 or 5 sets of data files. Each combined report
contains anywhere from 800 to 5000 rows of customer data.

After the first set of data is processed, the subsequent runs seem to be
much slower, even if the second or third data set is smaller than the first
one.

Is there something I need to do before processing these subsequent reports
that may make things run faster?

Thanks for any insights anyone can offer on this.

Ken Loomis