I've written a macro which generates a pre-defined series of
pivottables from a given datasource. I now need to enhance the code
so the user can easily define the location of the data, whether this
be in Excel or Access.

In a nutshell I need to use the forms which constitute Steps 1 and 2
of the Pivottable Wizard and then instead of displaying step 3 display
a userform of my construction. Is this at all possible or do I need
to design the forms and write the necessary the code myself?

I'm currently using Excel 2003 but note that Excel 2007 uses a
different "Pivottable wizard". When we migrate to Excel 2007 I accept
I would need to change the code a bit but think it is preferable to
use the native forms and code as much as possible.

Any help would be greatly appreciated.

Many thanks

Peter