connecting a pivot table to a data cube in VBA
 

Hello,
Thanks for taking the time to read this.
I am currently aiming to acheive the following things in a VBA excel
application
1) the user opens a custom .xlt file
2) on opening, the user is prompted to connect to a cube (be that on MS
Analysis Services, or an offline cube)
3) the user is then able to construct a pivot table based on his/her
selection above.
I am having trouble with step 2. I realise that there is a generic
wizard-like progression of forms native to Excel which allows the user to
connect to either a cube or an MS Analysis Server. Is there any way within
VBA code to kick this off?
Otherwise, is there another easy way to allow the flexibility of connecting
to either an Analysis Server or an offline cube?
Cheers and thanks,
Steve