Data provider types: Essbase, Planning (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)
HypPivotToGrid() moves the selected dimension and members from the POV to the spreadsheet grid.
HypPivotToGrid (vtSheetName, vtDimensionName, vtSelection)
ByVal vtDimensionName As Variant
ByVal vtSelection As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtDimensionName: The currently selected dimension from the toolbar
vtSelection:The range object that refers to the single cell starting point of the pivot. Orientation is calculated based on the selection.
Returns 0 if successful; otherwise, returns the appropriate error code.
Public Declare Function HypPivotToGrid Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtDimensionName As Variant, ByVal vtSelection As Variant) As Long Sub Example_PivotGrid() X = HypPivotToGrid(Empty, "Product", Range("E6")) If X = 0 Then MsgBox ("Pivot to grid successful.") Else MsgBox ("Pivot to grid failed.") End If End Sub