HypUseLinkMacro
Describes the Oracle Smart View for Office VBA function, HypUseLinkMacro.
Data provider types: Oracle Essbase, Planning (ad hoc only), Planning Modules (ad hoc only), Financial Consolidation and Close (ad hoc only), Tax Reporting (ad hoc only)
Descriptiopn
HypUseLinkMacro() specifies the type of link view: static or dynamic.
Note:
Static and dynamic link views share the same menu option; therefore, you must turn the flag on before performing the dynamic link query. When you are finished with dynamic link views, turn the flag off.
Syntax
HypUseLinkMacro (bUse)
ByVal bUse as Boolean
Parameters
bUse: Set to True to perform dynamic link. Set to False to perform static link.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Declare Function HypUseLinkMacro Lib "HsAddin" (ByVal bUse As Boolean) As Long
Sub Example_HypUseLinkMacro()
Sts = HypUseLinkMacro(True)
End sub