Data provider types: Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management, (ad hoc only), Hyperion Enterprise (ad hoc only)
HypGetLinkMacro() returns the macro name currently set to be run to perform the dynamic link query.
HypGetLinkMacro (vtMacroName)
ByRef vtMacroName As Variant
vtMacroName: Output parameter, returns the currently set macro name
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypGetLinkMacro Lib "HsAddin" (ByRef vtMacroName As Variant) As Long Sub Example_HypGetLinkMacro() Dim Macroname As Variant Sts = HypUseLinkMacro(True) Sts = HypSetLinkMacro("Sheet1.Macro8") Sts = HypGetLinkMacro(Macroname) If (StrComp(MacroName, "Sheet1.Macro8")) Then MsgBox ("Error Occurred") End If End Sub