HypDeleteLROs
Cloud data provider types: Oracle Analytics Cloud - Essbase
On-premises data provider types: Oracle Essbase
Description
HypDeleteLROs() deletes one or more linked reporting objects from the cells specified by the vtSelectionRange parameter.
Syntax
HypDeleteLROs (vtSheetName, vtSelectionRange, vtLROIDs())
ByVal vtSheetName As Variant
ByVal vtSelectionRange As Variant
ByRef vtLROIDs() As Variant
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 delete all linked reporting objects
vtLROIDs(): Input variable; the array of LRO Ids to be deleted
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Public Declare Function HypDeleteLROs Lib "HsAddin" (ByVal vtSheetName As Variant,ByVal vtSelectionRange As Variant, ByRef vtLROIDs() As Variant) As Long
Sub Example_HypDeleteLROs()
Dim LROIDs(1)
LROIDs(0) = 1
LROIDs(1) = 2
sts = HypDeleteLROs("Sheet1", Range("B3"), LROIDs)
End Sub