Data provider types: Planning
HypPerformAdhocOnForm() enables ad hoc analysis in Excel worksheets for Planning web forms.
HypPerformAdhocOnForm(vtSheetName, vtFormName)
ByVal vtSheetName As Variant
ByVal vtFormName As Variant
vtSheetName: Input variable; the name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtFormName: Input variable; the name of the Planning web form, including its full path; for example, /Forms/Financials/Financials Summary
Returns 0 if successful; otherwise, returns the appropriate error code.
Public Declare Function HypPerformAdhocOnForm Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtFormName As Variant) As Long Sub Example_PerformAdhocOnForm sts = HypPerformAdhocOnForm(Empty, "/Forms/Financials/Financials Summary") End Sub