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
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
 
You must log in or register to reply here.

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

Similar Threads

#Value in Analysis Services Pivot Table 1
Excel 2007 Cube access problems 5
Excel cube functions 2
MDX query in Excel 1
Access #Error & Excel Pivot 0
Executing custom MDX queries in Excel'2007 8
Question on the occupied field of the pivot table in excel spreadsheet 0
How can I view comments in a pivottable? 1

Back
Top