Data provider types: Essbase, Planning (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)
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. |
HypSetLinkMacro (vtMacroName)
ByVal vtMacroName As Variant
vtMacroName: The name of the macro to be run
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypSetLinkMacro Lib "HsAddin" (ByVal vtMacroName As Variant) As Long Sub Example_HypSetLinkMacro() Sts = HypUseLinkMacro(True) Sts = HypSetLinkMacro("Sheet1.Macro8") End Sub