topic Re: Passing parameters to Macro's when called by button in QlikView

Passing parameters to Macro's when called by button

Anonymous — Wed, 25 Feb 2015 04:06:56 GMT

On edit Module (Javascript)

function alertJS1() {

var x=new ActiveXObject("WScript.Shell");

x.popup('works');

}

function alertJS(s) {

var x=new ActiveXObject("WScript.Shell");

x.popup(y);

}

On Button - in External - Macro - alertJS1 is okay

On Button - in External - Macro - alertJS('any message') not okay

rwunderlich — Wed, 25 Feb 2015 04:37:14 GMT

The Action -> Run Macro does not pass parameters. Possible workarounds are:

1. Set a variable value before calling the macro. And then read the variable value in the macro.

2. Use Multiple (differently named) Subs that call the main sub, passing a parameter.

-Rob

Anonymous — Wed, 25 Feb 2015 04:49:58 GMT

correct.

Tkx

rwunderlich — Wed, 25 Feb 2015 06:24:47 GMT

You can mark an answer as correct which will close the thread.

Rob