Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Follow these
tried the same, but not working.
Also when i trigger, i am not able to hide the command prompt window.
Not sure about it may be write another macro to close it.
Once the activity is done, window will close on its own. But i don't want even window to visible to user.
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