MDX excel pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
Can any body help me to find mdx queries behind of pivot table in excel 2007
beta. Thanks in advance
Mohsen
 
Mohsen said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top