How to hide script execution window while loading from batch file

[#1]

Hi Team,

I am using below mentioned statement in batch file to run macro. But this script execution window is showing while load. Request you to help to hide this window so macro can run successfully.

"C:\Program Files\QlikView\Qv.exe" /L D:\FoodsMIS\Application\Email.qvw

Regards,

Kapil

[mayankraoka]

Hi Kapil,

You have to use this .vbs file:

Save the following line as invisible.vbs (use Notepad Save As... All Files)

CreateObject("Wscript.Shell").Run """" & WScript.Arguments(0) & """", 0, False

Confirm you have Scripting installed (By typing wscript in the Start Run dialog)

Start Run the following line, Replace the "MySubFolder" with your file paths

wscript "C:\MySubfolder\invisible.vbs" "C:\MySubfolder\MyBatchFile.bat"

Regards,

Mayank

[marcus_sommer]

Instead of the parameter /L use /R:

"C:\Program Files\QlikView\Qv.exe" /R D:\FoodsMIS\Application\Email.qvw

- Marcus

[#4]

Hi Marcus,

I am using /R but macro is not running on post reload. Request you to help me on this.

Regards,

Kapil

[marcus_sommer]

In general OnPostReload macros should work by batch-execution with the parameter /L. But easier and more flexible are vbs-batches or vbs from inside another qvw - most often I use this approach. Here are further hints what could be possible:

Re: QlikView Batch Jobs execution using CONTROL-M‌

Reduce Number of Applications at a time

- Marcus