Discussion Board for collaboration on QlikView Scripting.
How Can I execute a batch file inside a macro?
I'm creating a Run Method (Windows Script Host) to execute the batch file but it doesn't run...
Have anyone already create a macro to run a batch file successfully? Or have a better ideia to run the script of a batch file?
Go to Solution.
Opening or Reload? Anyway, Go to Settings -> Document Properties -> Triggers:
You can just when you want to run the macro from Document Event Triggers
And then click on Add Action(s) -> Add -> External -> Run Macro:
Just type the macro name into Macro Name text box:'
This should do it.
Go to Tools -> Edit Module and then plug the below vbscript/macro:
Set obj = createobject("Wscript.Shell")
obj.Run chr(34) & "Full_Path_To_Your_bat_File" & chr(34), 0
Set obj = Nothing
Then assign this to button or any other object.
Hope this helps.
Thanks Sinan Ozdemir!
But I want to have that code when opening the application (Reload), is that possible?
Thanks a lot!!!
Sorry for one more question...
In your code is possible to hide the execution window?
Do you mean the cmd window?
No problem. You are welcome.
Thank you very much!
In your macro, add the below code:
0 is for Error Mode and 1 is for Progress Mode