HypGetNameRangeList

Data source types: Essbase

Description

HypGetNameRangeList returns a list of named grids for a given connection.

Syntax

HypGetNameRangeList (vtSheetName, vtConnName, vtNameList)

ByVal vtSheetName As Variant

ByVal vtConnName As Variant

ByRef vtNameList As Variant

Parameters

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

vtConnName: Input variable, contains the connection name whose specific list of name ranges must be retrieved. If this is empty then all the name range list in the sheet will be retrieved

vtNameList: Contains the list output.

Return Value

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

Example

Sub HypGetNameRangeList()
sts = HypGetNameRangeList("Sheet1", "stm10026_Sample_Basic", vtList)
End Sub