HypSetActiveConnection
Describes the Oracle Smart View for Office VBA function, HypSetActiveConnection.
Cloud data provider types: Oracle Analytics Cloud - Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management
Description
HypSetActiveConnection() associates the current active worksheet with one of the active connections.
Note:
HypSetActiveConnection does not work with worksheets that contain Report Designer objects
Syntax
HypSetActiveConnection (vtFriendlyName)
ByVal vtFriendlyName As Variant
Parameters
vtFriendlyName: The friendly name of the active connection 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 vtFriendlyName As Variant) As Long
Sub Example_SetActiveConnection()
sts = HypSetActiveConnection ("Demo_Basic")
End sub