Data provider types: Planning, Oracle Planning and Budgeting Cloud, Financial Management, Hyperion Enterprise
HypOpenForm () opens the specified form.
HypOpenForm (vtSheetName, vtFolderPath, vtFormName, vtDimensionList(), vtMemberList())
ByVal vtSheetName As Variant
ByVal vtFolderPath As Variant
ByVal vtFormName As Variant
ByRef vtDimensionList() As Variant
ByRef vtMemberList() As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtFolderPath: The folder path name
vtFormName: The name of the data form
vtDimensionList(): not in use
vtMemberList(): not in use
Returns 0 if successful; otherwise, returns the appropriate error code.
Public Declare Function HypOpenForm Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtFolderPath As Variant, ByVal vtFormName As Variant, ByRef vtDimensionList() As Variant, ByRef vtMemberList() As Variant) As Long Sub Example_HypOpenForm() Dim DimList() As Variant Dim MemList() As Variant sts = HypOpenForm(Empty, "/Forms/data1", "data1", DimList, MemList) MsgBox (sts) End Sub