HypRetrieveLRO

HypRetrieveLRO() retrieves linked reporting objects associated with the cells specified by the vtSelectionRange parameter.

HypRetrieveLRO(vtSheetName, vtSelectionRange, vtID,vtlType, vtName, vtDescription)

ByVal vtSheetName As Variant

ByVal vtSelectionRange As Variant

ByVal vtID As Variant

ByVal vtName As Variant

ByVal vtDescription As Variant

vtSheetName: For future use; currently the active sheet is used.

vtSelectionRange: Input parameter; the range of cells to associate with the linked reporting object.

vtID: Input parameter;the ID of the linked reporting object to be retrieved. This is provided when you execute HypListLROs.

vtName: Output parameter;the name of the linked reporting object

vtDescription: Output parameter;the description of the retrieved linked reporting object.

Returns 0 if successful; otherwise, returns the corresponding error code.

Public Declare Function HypRetrieveLRO Lib "HsAddin" (ByVal vtSheetName As Variant,ByVal vtSelectionRange As Variant,ByVal vtID,ByRef vtName,ByRef vtDescription) As Long

Sub HypRetrieveLRO
sts = HypRetrieveLRO("Sheet1", Range("B3"), "1", vtName, vtDescription)
End Sub