HypConnect

HypConnect() logs into a data source 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 vtSheetName As Variant

ByVal vtUserName As Variant

ByVal vtPassword As Variant

ByVal vtFriendlyName As Variant

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

vtUserName: Text name of a valid user for the data source provider.

vtPassword: Text name of the password for this user.

vtFriendlyName: The friendly connection name for the data source 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 Conn()
   X=HypConnect(Empty, username, password, “My Sample Basic”)
End Sub