HypListLROs

Data source types: Essbase

Description

HypListLROs() lists all linked reporting objects associated with the cells specified by the vtSelectionRange parameter.

Syntax

HypListLROs (vtSheetName,vtSelectionRange,vtLRO As LRO_Info)

ByVal vtSheetName As Variant

ByVal vtSelectionRange As Variant

ByRef vtLRO As LRO_Info

Parameters

vtSheetName: For future use. Currently the active sheet is used.

vtSelectionRange: Input parameter; the range of cells from which to list all linked reporting objects

vtLRO: Output parameter; 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 LRO_Info) As Long

Dim ObjectList As LRO_Info
Sub HypListLROs()
sts = HypListLROs("Sheet1", Range("B3"), ObjectList)
End Sub