MDX excel pivot table

[Mohsen]

Hello
Can any body help me to find mdx queries behind of pivot table in excel 2007
beta. Thanks in advance
Mohsen

[MHAlexander@gmail.com]

Mohsen wrote:
> Hello
> Can any body help me to find mdx queries behind of pivot table in excel 2007
> beta. Thanks in advance
> Mohsen

Use the MDX property to do this

Sub CheckMDX()
Dim strMDX As String
strMDX = ActiveSheet.PivotTables(1).MDX
MsgBox strMDX
End Sub