Data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Hyperion Financial Management
Description
HypSubmitData() updates the database with modified data from the specified spreadsheet.
Note:
HypSubmitData() is not supported with aggregate storage databases or in a clustered environment.
The ability to update the database depends on the access permissions of the submitter. To update data, you must have at least Write access to the database.
Syntax
HypSubmitData(vtSheetName)
ByVal vtSheetName 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.
Return Value
For forms: Returns 0 if form is submitted successfully; otherwise, returns the appropriate error code.
For ad hoc: Returns 0 if ad hoc grid is submitted successfully and HsSetVal functions, if any, were run. Returns 1 if the sheet was not connected but HsSetVal functions, if any, were run. Returns 2 if sheet had no ad hoc grid but HsSetVal functions, if any, were run. Otherwise, returns the appropriate error code.
Example
Declare Function HypSubmitData Lib "HsAddin" (ByVal vtSheetName As Variant) As Long
Sub Example_HypSubmitData()
Worksheets(Empty).range("B2").value = 8023
Worksheets(Empty).range("B2").Select
sts = HypSubmitData(Empty)
End Sub