topic Re: How to hide script execution window while loading from batch file in QlikView

How to hide script execution window while loading from batch file

Fri, 04 Dec 2015 03:32:01 GMT

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

Re: How to hide script execution window while loading from batch file

mayankraoka — Fri, 04 Dec 2015 17:55:04 GMT

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

Re: How to hide script execution window while loading from batch file

marcus_sommer — Fri, 04 Dec 2015 20:08:57 GMT

Instead of the parameter /L use /R:

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

- Marcus

Re: How to hide script execution window while loading from batch file

Sat, 05 Dec 2015 03:20:16 GMT

Hi Marcus,

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

Regards,

Kapil

Re: How to hide script execution window while loading from batch file

marcus_sommer — Sun, 06 Dec 2015 15:35:33 GMT

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