HypSetLinkMacro

Data source types: Essbase, Planning (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)

Description

HypSetLinkMacro() sets the macro name to be run to perform the dynamic link query action.

Note:

Once the link action is triggered from the Visualize in Excel menu item, the macro name set by this function name will be run.

Note:

This function is used specifically with dynamic link views, as described in VBA Functions and Dynamic Link Views..

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 Auto_Open()
  Sts = HypUseLinkMacro(True)
  Sts = HypSetLinkMacro(“Sheet1.Macro8”)
End Sub