Data provider types: Essbase, Planning, Financial Management, Hyperion Enterprise
HypSetActiveConnection() associates the current active worksheet with one of the active connections.
Note: | HypSetActiveConnection does not work with worksheets that contain Report Designer objects |
HypSetActiveConnection (vtFriendlyName)
ByVal vtFriendlyName As Variant
vtFriendlyName: The friendly name of the active connection to be associated with the current active worksheet. It is not case-sensitive.
Long. If successful, return value is 0; otherwise, the appropriate error code is returned.
Declare Function HypSetActiveConnection Lib "HsAddin" (ByVal vtFriendlyName As Variant) As Long Sub Example_SetActiveConnection() sts = HypSetActiveConnection ("Demo_Basic") End sub