Data provider types: Essbase, Planning, Financial Management, Hyperion Enterprise
HypConnect() logs into a data provider and associates the worksheet with that connection. HypConnect() must be called for each sheet in order to associate this connection with that sheet.
HypConnect(vtSheetName, vtUserName, vtPassword, vtFriendlyName)
ByVal vtUserName As Variant
ByVal vtPassword As Variant
ByVal vtFriendlyName As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtUserName: A valid user name
vtPassword: The password for this user
vtFriendlyName: The friendly connection name of the data provider. This is the connection name created by HypCreateConnection.
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypConnect Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtUserName As Variant, ByVal vtPassword As Variant, ByVal vtFriendlyName As Variant) As Long Sub Example_HypConnect() X=HypConnect(Empty, UserName, Password, "My Sample Basic") End Sub