MDX Pivot Table

Hi Everybody:
I have only SQL Server 2000, AS and Office 2000... and i need to build a
customized Excel VBA system with drill-down & drill-up functionality from an
Analysis Services cube. I would like to avoid a lot of VBA/MDX program
code...so the question is: can i control Excel 2000 Pivot Table from VBA MDX
code?... i mean, to fill the PivotTable from a specific MDX query, remaining
the pivot-table functionality...
Thanks a lot...
RodrigoNo.
"Rodrigo" <Rodrigo@.discussions.microsoft.com> wrote in message
news:858EE816-20D8-4FA8-9020-EF0A4DDB4123@.microsoft.com...
> Hi Everybody:
> I have only SQL Server 2000, AS and Office 2000... and i need to build a
> customized Excel VBA system with drill-down & drill-up functionality from
> an
> Analysis Services cube. I would like to avoid a lot of VBA/MDX program
> code...so the question is: can i control Excel 2000 Pivot Table from VBA
> MDX
> code?... i mean, to fill the PivotTable from a specific MDX query,
> remaining
> the pivot-table functionality...
> Thanks a lot...
> Rodrigo