HypSetLinkMacro
Cloud data provider types: Oracle Analytics Cloud - Essbase, Planning (ad hoc only), Planning Modules (ad hoc only), Financial Consolidation and Close (ad hoc only), Tax Reporting (ad hoc only)
On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning (ad hoc only), Oracle Hyperion Financial Management (ad hoc only)
Description
HypSetLinkMacro() sets the macro name to be run to perform the dynamic link query action.
Note:
When the link action is triggered from the Visualize in Excel menu item, the macro set by this function will be run.
Syntax
HypSetLinkMacro (vtMacroName)
ByVal vtMacroName As Variant
Parameters
vtMacroName: The name of the macro to be run
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Declare Function HypSetLinkMacro Lib "HsAddin" (ByVal vtMacroName As Variant) As Long
Sub Example_HypSetLinkMacro()
Sts = HypUseLinkMacro(True)
Sts = HypSetLinkMacro("Sheet1.Macro8")
End Sub