topic Actions : how to run macro with parameters ? in QlikView

Actions : how to run macro with parameters ?

Thu, 02 Sep 2010 08:50:53 GMT

I've a simple question :

I've a macro which use a string in parameter :


sub mymacro (message)
...
end sub

how to call it with an action ?
I mean there is an action / External / Run Macro. It works with macro without parameter (i write only the macro name). But I'm fighting to find the syntax to add a string parameter in this macro launch (for example to launch mymacro("my string parameter") with action).

Best regards

P.S : I'm working with V9 SR4

Actions : how to run macro with parameters ?

kji — Thu, 02 Sep 2010 09:00:58 GMT

I don't think you can pass parameters to macros, but you could use a variable to pass the information.

Actions : how to run macro with parameters ?

Thu, 02 Sep 2010 09:14:56 GMT

You mean get variable info in VBscript using command such as
ActiveDocument.Variables("Variable1").GetContent.String ?

I was hoping to avoid this 🙂 ... but if there is no direct solution ...