Data provider types: Essbase, Planning, Financial Management, Hyperion Enterprise
HypGetSharedConnectionsURL() returns the Shared Connections URL to be used (also shown in the Options dialog box).
HypGetSharedConnectionsURL (vtSharedConnURL)
ByRef vtSharedConnURL As Variant
vtSharedConnURL: Output parameter; the Shared Connections URL
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypGetSharedConnectionsURL Lib "HsAddin" (ByRef vtSharedConnURL As Variant) As Long Sub Example_HypGetSharedConnectionsURL() Dim lRet As Long Dim conn As Variant lRet = HypGetSharedConnectionsURL(conn) MsgBox (lRet) MsgBox (conn) End Sub