Data provider types: Oracle Essbase, Oracle Hyperion Planning (ad hoc only), Oracle Planning and Budgeting Cloud (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