HypSetActiveConnection

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

Description

HypSetActiveConnection() is used to associate the current active worksheet with one of the active connections.

Note:

HypSetActiveConnection does not work with worksheets that contain Report Designer objects

Syntax

HypSetActiveConnection (vtConnectionName)

ByVal vtConnectionName as Variant

Parameters

vtConnectionName: Name of the active connection which is to be associated with the current active worksheet. It is not case-sensitive.

Return Value

Long. If successful, return value is 0; otherwise, the appropriate error code is returned.

Example

Declare Function HypSetActiveConnection Lib "HsAddin" (ByVal vtConnectionName As Variant) As Long

Sub Sample_SetActiveConnection
   sts = HypSetActiveConnection (“Demo_Basic”)
End sub