HypAddLRO

Data source types: Essbase

Description

HypAddLRO() adds linked reporting objects to the cells specified by the vtSelectionRange parameter.

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: For future use; currently the active sheet 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 parameter; the location of the file with filename and URL information. Not used for cell note.

vtDescription: Input parameter; 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) As Long

Sub HypAddLRO()
 sts = HypAddLRO("Sheet1", Range("B3"), 1, "", "Hello World")
End Sub