HypGetNameRangeList
Describes the Oracle Smart View for Office VBA function, HypGetNameRangeList.
Cloud data provider types: Oracle Essbase
On-premises data provider types: Oracle Essbase
Description
HypGetNameRangeList returns a list of named grids for a given connection.
Syntax
HypGetNameRangeList (vtSheetName, vtFriendlyName, vtNameList)
ByVal vtSheetName As Variant
ByVal vtFriendlyName As Variant
ByRef vtNameList 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.
vtFriendlyName: Input parameter; the connection name whose list of name ranges are to be retrieved. If set to Empty, all name range lists in the sheet are retrieved.
vtNameList: Output parameter; the list output.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Public Declare Function HypGetNameRangeList Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtFriendlyName As Variant, ByRef vtNameList As Variant) As Long
Sub Example_HypGetNameRangeList()
sts = HypGetNameRangeList("Sheet1", "stm10026_Sample_Basic", vtList)
End Sub