QueryTable using PivotTable's datasource

Is it possible to change the connection of a QueryTable to that of a PivotTable (Analysis Server Cube & MDX)?

As far I figure, the QueryTable create a recordset itself. I can create a normal recordset in code using a mdx query, but cannot successfully create a querytable to do this.

I do not want the result of the query in a pivottable, I want it in a querytable and be able to refresh the worksheet.

please help or direct me to where I can get help...please please