ExcelBanter - MDX excel pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - MDX excel pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/102406-mdx-excel-pivot-table.html)

Mohsen

MDX excel pivot table

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

[email protected]

MDX excel pivot table

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

All times are GMT +1. The time now is 07:18 AM.