topic Re: Create a Macro to run a Batch File in QlikView

Create a Macro to run a Batch File

Mon, 04 Jan 2016 19:50:09 GMT

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?

Thanks!

Re: Create a Macro to run a Batch File

sinanozdemir — Mon, 04 Jan 2016 21:12:49 GMT

Hi,

Go to Tools -> Edit Module and then plug the below vbscript/macro:

Sub Run_BAT

Set obj = createobject("Wscript.Shell")

obj.Run chr(34) & "Full_Path_To_Your_bat_File" & chr(34), 0

Set obj = Nothing

End Sub

Then assign this to button or any other object.

Hope this helps.

Re: Create a Macro to run a Batch File

Mon, 04 Jan 2016 22:11:36 GMT

Thanks Sinan Ozdemir!

But I want to have that code when opening the application (Reload), is that possible?

Re: Create a Macro to run a Batch File

sinanozdemir — Mon, 04 Jan 2016 22:21:51 GMT

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.

Re: Create a Macro to run a Batch File

Mon, 04 Jan 2016 22:25:25 GMT

Perfect Sinan

Thanks a lot!!!

Re: Create a Macro to run a Batch File

Mon, 04 Jan 2016 22:52:43 GMT

Sorry for one more question...

In your code is possible to hide the execution window?

Re: Create a Macro to run a Batch File

sinanozdemir — Mon, 04 Jan 2016 23:30:28 GMT

Do you mean the cmd window?

Re: Create a Macro to run a Batch File

sinanozdemir — Mon, 04 Jan 2016 23:30:47 GMT

No problem. You are welcome.

Re: Create a Macro to run a Batch File

Mon, 04 Jan 2016 23:32:16 GMT

No,

This window:

Thank you very much!

Re: Create a Macro to run a Batch File

sinanozdemir — Tue, 05 Jan 2016 00:08:16 GMT

In your macro, add the below code:

ActiveDocument.ReloadEx 0,1

0 is for Error Mode and 1 is for Progress Mode

Hope this helps.

Re: Create a Macro to run a Batch File

Tue, 05 Jan 2016 00:24:31 GMT

I think I don't understand very well:

SUB Run

ActiveDocument.ReloadEx 0,1

Set obj = createobject("Wscript.Shell")

obj.Run chr(34) & "PATH\teste.bat" & chr(34), 0, true

Set obj = Nothing

END SUB

The window it still appear

Thanks very much!

Re: Create a Macro to run a Batch File

sinanozdemir — Tue, 05 Jan 2016 01:31:13 GMT

What is the trigger that you are choosing to run the macro?

I just tried it on "OnOpen" and the window didn't appear.

Re: Create a Macro to run a Batch File

Tue, 05 Jan 2016 09:18:51 GMT

It's strange because when I save the application and I reset the application to aperece window with the execution of the script . If you close the application without saving , and re-do reset , the window no longer appears ... Very strange

Re: Create a Macro to run a Batch File

sinanozdemir — Tue, 05 Jan 2016 13:43:22 GMT

What are the module and local security setting in the Edit Module screen?

Re: Create a Macro to run a Batch File

Tue, 05 Jan 2016 14:10:40 GMT

I have the same but sometimes it change to default current local security value (Security Mode)