Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a Macro to run a Batch File

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!

1 Solution

Accepted Solutions
sinanozdemir
Specialist III
Specialist III

Opening or Reload? Anyway, Go to Settings -> Document Properties -> Triggers:

You can just when you want to run the macro from Document Event Triggers

Capture.PNG

And then click on Add Action(s) -> Add -> External -> Run Macro:

Capture.PNG

Just type the macro name into Macro Name text box:'

Capture.PNG

This should do it.

View solution in original post

14 Replies
sinanozdemir
Specialist III
Specialist III

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.

Not applicable
Author

Thanks Sinan Ozdemir!

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

sinanozdemir
Specialist III
Specialist III

Opening or Reload? Anyway, Go to Settings -> Document Properties -> Triggers:

You can just when you want to run the macro from Document Event Triggers

Capture.PNG

And then click on Add Action(s) -> Add -> External -> Run Macro:

Capture.PNG

Just type the macro name into Macro Name text box:'

Capture.PNG

This should do it.

Not applicable
Author

Perfect Sinan

Thanks a lot!!!

Not applicable
Author

Sorry for one more question...

In your code is possible to hide the execution window?

sinanozdemir
Specialist III
Specialist III

Do you mean the cmd window?

sinanozdemir
Specialist III
Specialist III

No problem. You are welcome.

Not applicable
Author

No,

This window:

Thank you very much!

sinanozdemir
Specialist III
Specialist III

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.