Many Pivottables created in bva
 

I have 20 + pivottables linked in to an Access XP database. Each PT is based
on its own Access Select query with a Where clause. Im using a
ADODB.connection and connectionstring and all the bits that go with it. I
set up a pivottable cache and table in vba together with the pt layout for
each worksheet. One sheet = one pt. All these pts are rebuilt at workbook
open time.

80% of these 20+ procedures are the same, the variable bits are the queries
and their fields(the connection strings).



The question: To reduced this duplication should use a Class Module or is
there another approach?
TIA.
Regards
johnb