Passing parameters to Macro's when called by button

[Anonymous]

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 · Accepted solution]

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]

correct.

Tkx

[rwunderlich]

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

Rob