HypCell

Data source types: Essbase, Planning, Financial Management, Hyperion Enterprise

Description

HypCell() retrieves a cell value for a single member combination.

Syntax

HypCell(vtSheetName, ParamArray MemberList())

ByVal vtSheetName As Variant

ByVal ParamArray MemberList() As Variant

Parameters

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

MemberList: A list of strings that describe the member combination for which a data value will be retrieved. If MemberList is Null or Empty, the top level value is used. Represent members as “Dimension#Member”; for example, “Year#Jan” or “Market#East”.

Return Value

Returns the value of the data point if successful. Returns #No Connection if the sheet cannot be determined or is not connected to a data source. Returns “Invalid Member MemberName or dimension DimensionName” if a member is incorrect.

Example

Declare Function HypCell Lib "HsAddin" (ByVal vtSheetName As Variant, ParamArray MemberList() As Variant) As Variant

Sub InCell()
Dim X As String
X=HypCell(Empty, "Year#Qtr1", "Scenario#Actual", "Market#Oregon")
    If X = "#No Connection" Then
       MsgBox("Not logged in, or sheet not active.")
    Else
       If Left(X, 15) = "#Invalid member" then
          MsgBox("Member name incorrect.")
       Else
          MsgBox(X + " Value retrieved successfully.")
       End If
    End If
End Sub

Note:

The value of the data point returned is not placed in a cell in the spreadsheet automatically. To place the value in a cell, use the Visual Basic select method and the ActiveCell property. See your Visual Basic documentation for more information.