topic Re: Call Macro from Script in QlikView

Call Macro from Script

goro2010 — Tue, 23 May 2017 14:14:43 GMT

Good Day,

I have this QVW that is calling a BAT document.

Script:

EXECUTE cmd.exe /C C:\QVD\MacroReload.bat;

EXIT SCRIPT;

BAT Script:

"c:\Program Files (x86)\qlikView\QV.exe" /VvReloadMacro=2 "C:\QVD\Test.qvw"

The idea is, that when the variable ReloadMacro is equal to two, then it should execute a Macro without clicking a button.

Is this possible?

Thank You

Re: Call Macro from Script

ahaahaaha — Tue, 23 May 2017 14:27:25 GMT

Hi Jan,

May be it be through running a macro when changing a variable in a document's properties?

Regards,

Andrey

Re: Call Macro from Script

goro2010 — Tue, 23 May 2017 14:34:19 GMT

Hi Andrey,

This feels like the way I need to go, I have made the changes.

BAT file does change the variable, but the Macro did not fire?

Any suggestion why?

Thank You

Re: Call Macro from Script

tamilarasu — Tue, 23 May 2017 14:44:28 GMT

Hi Jan,

Could you explain us how are you changing the variable i.e vReloadMacro as 2? It would be easy for us to help you further.

Re: Call Macro from Script

goro2010 — Tue, 23 May 2017 14:48:12 GMT

Hi Tamil,

I am doing it via BAT Script.

The script opens the QVW and then set the variable to 2

BAT Script:

"c:\Program Files (x86)\qlikView\QV.exe" /VvReloadMacro=2 "C:\QVD\Test.qvw"

Thank You

Re: Call Macro from Script

tamilarasu — Tue, 23 May 2017 14:53:41 GMT

Jan,

I am not clear about your requirement. Do you want to run the macro in the same qvw file which calling the BAT file? If possible, could you attach a small sample and explain us?

Re: Call Macro from Script

goro2010 — Tue, 23 May 2017 14:59:52 GMT

Hi Guys,

I have managed to change it and get it working, Andrey gave me the right place to look at

What I have done..

I have created another Macro:

IF ReloadMacro = 2 THEN

CALL ReloadMacro2

ETC......

And I have made the trigger on (OnOpen), and call ReloadMacro

Thank You!!!!

Re: Call Macro from Script

tamilarasu — Tue, 23 May 2017 15:06:04 GMT

Great Jan!! Glad that you found the solution by yourself with all your effort. Sorry I could not help you out, since I was not sure what was your requirement. Have a good day!!

Re: Call Macro from Script

goro2010 — Tue, 23 May 2017 15:09:31 GMT

Tamil,

The idea behind a community forum is not to be spoon fed everything

Just to be pointed in the correct direction and then to figure it out by yourself and to learn out of your mistakes

Thank You All!

Re: Call Macro from Script

tamilarasu — Tue, 23 May 2017 15:14:55 GMT

Ha ha. I completely agree with your point. BTW, I was not able to provide any valid point in this case .

Re: Call Macro from Script

cmccafferty — Fri, 15 Feb 2019 15:31:37 GMT

I'm really struggling with this one... I want my Macro to execute when the data is Reloaded.

At the minute I can get it to work via a macro button, but is it possible to save down the three files i need when the script is executed?