Data provider types: Essbase
HypGetNameRangeList returns a list of named grids for a given connection.
HypGetNameRangeList (vtSheetName, vtFriendlyName, vtNameList)
ByVal vtSheetName As Variant
ByVal vtFriendlyName As Variant
ByRef vtNameList As Variant
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.
Returns 0 if successful; otherwise, returns the appropriate error code.
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