HypOpenForm
Describes the Oracle Smart View for Office VBA function, HypOpenForm.
Cloud data provider types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
On-premises data provider types: Oracle Hyperion Planning, Oracle Hyperion Financial Management
Description
HypOpenForm () opens the specified form.
Syntax
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
Parameters
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
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
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