Data provider types: Essbase
HypListLROs() lists all linked reporting objects associated with the cells specified by the vtSelectionRange parameter.
HypListLROs (vtSheetName, vtSelectionRange, vtLRO)
ByVal vtSheetName As Variant
ByVal vtSelectionRange As Variant
ByRef vtLRO As LRO_Info
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
Returns 0 if successful; otherwise, returns the appropriate error code.
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