MDX excel pivot table

M

Mohsen

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

MHAlexander

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

Use the MDX property to do this

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