HypMenuVCascadeNewWorkbook
Data source types: Essbase, Planning, Hyperion Enterprise
HypMenuVCascadeNewWorkbook() cascades separate reports for members of one dimension across worksheets of a newly-opened Excel workbook.
HypMenuVCascadeNewWorkbook()
Returns 0 if successful; otherwise, returns the appropriate error code.
Public Declare Function HypMenuVCascadeNewWorkbook Lib "HsAddin" () As Long
Sub MCascadeNewWorkbook()
X=HypMenuVCascadeNewWorkbook()
End Sub