Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table accessing data from OLAP cube | Excel Worksheet Functions | |||
Excel Error while connecting to OLAP cube | Excel Discussion (Misc queries) | |||
Connecting a Pivot Table to .Tab Data file ** Minimise the connexion setup hassle | Excel Discussion (Misc queries) | |||
suppress warning and locate cube in a pivot table from olap cube | Excel Discussion (Misc queries) | |||
Pivot Table - OLAP Cube | Excel Discussion (Misc queries) |