Data provider types: Essbase, Planning, Financial Management, Hyperion Enterprise
HypCell() retrieves a cell value for a single member combination.
HypCell(vtSheetName, ParamArray MemberList())
ByVal ParamArray MemberList() As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet 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”.
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 provider. Returns “Invalid Member MemberName or dimension DimensionName” if a member is incorrect.
Declare Function HypCell Lib "HsAddin" (ByVal vtSheetName As Variant, ParamArray MemberList() As Variant) As Variant Sub Example_HypCell() 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