Execution of Batch file using Macro

[manojkulkarni]

Hi All,

I am using a batch file to upload data to FTP location. Below code is being used in macro to run batch on click event of button. But it is not working. Same code when i put it in .vbs file and execute outside qlik it works fine. Even executing batch file manually outside qlik is also working fine. So i don't see any problem with the below code, but does it require any special permission or does any configuration to be done in qlik to work .

I expect some advise or help from experts.

Dim obj,oArgs

Set obj = CreateObject("WScript.Shell")

obj.Run "C:\ftpUpload.bat ", , TRUE

[sujeetsingh]

Follow these

https://community.qlik.com/thread/3923

[manojkulkarni]

tried the same, but not working.

Also when i trigger, i am not able to hide the command prompt window.

[sujeetsingh]

Not sure about it may be write another macro to close it.

[manojkulkarni]

Once the activity is done, window will close on its own. But i don't want even window to visible to user.

[petter]

If you use the:

obj.Run "c:\test.bat " & oArgs(0), , TRUE

You can just add the second parameters which is left empty over which specify how the Windows should be shown/hidden...

Hiding the window:

obj.Run "c:\test.bat " & oArgs(0), 0 , TRUE