HypAddLRO
Cloud data provider types: Oracle Analytics Cloud - Essbase
On-premises data provider types: Oracle Essbase
Description
HypAddLRO() adds linked reporting objects to the cells specified by the vtSelectionRange parameter. To see the added linked reporting objects, you must launch the Linked Reporting Objects dialog box or or use HypListLRO.
Syntax
HypAddLRO(vtSheetName, vtSelectionRange, vtlType, vtName, vtDescription)
ByVal vtSheetName As Variant
ByVal vtSelectionRange As Variant
ByVal vtlType As Variant
ByVal vtName As Variant
ByVal vtDescription 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.
vtSelectionRange: Input parameter; the range of cells to associate with the linked reporting object
vtlType: Input parameter; the linked reporting object type expressed as a constant
-
1—Cell note
-
2—File
-
3—URL
vtName: Input variable; the location of the file with filename and URL information. Not used for cell note.
vtDescription: Input variable; the description of the cell note, file, or URL
Return Value
Returns 0 if successful; otherwise, returns the corresponding error code.
Example
Public Declare Function HypAddLRO Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtSelectionRange As Variant, ByVal vtlType As Variant, ByVal vtName As Variant, ByVal vtDescription As Variant, ByRef vtLROIDs() As Variant) As Long
Sub Example_HypAddLRO()
sts = HypAddLRO("Sheet1", Range("B3"), 1, "", "Hello World")
End Sub