HypListLROs
Describes the Oracle Smart View for Office VBA function, HypListLROs.
Cloud data provider types: Oracle Analytics Cloud - Essbase
On-premises data provider types: Oracle Essbase
Description
HypListLROs() lists all linked reporting objects associated with the cells specified by the vtSelectionRange parameter.
Syntax
HypListLROs (vtSheetName, vtSelectionRange, vtLRO)
ByVal vtSheetName As Variant
ByVal vtSelectionRange As Variant
ByRef vtLRO As LRO_Info
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 variable; the range of cells from which to list all linked reporting objects
vtLRO: Output variable; the 2-dimensional array of linked reporting objects
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Public Declare Function HypListLROs Lib "HsAddin" (ByVal vtSheetName As Variant,ByVal vtSelectionRange As Variant,ByRef vtLRO) As Long
Dim ObjectList As LRO_Info
Sub Example_HypListLROs()
sts = HypListLROs("Sheet1", Range("B3"), ObjectList)
End Sub