Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to run an executable from a QlikView macro but the macro stops at the run line with no error message. My Requested Module Security is set to System Access and the Current Local Security is set to Allow System Access.
Here is my code
Set shell = CreateObject("WScript.Shell")
shell.Run "C:\Program.exe"
Why does the macro just stop?
Thanks
I found my error.
the program I was trying to run was in a folder with spaces so more like
shell.run "C:\a folder\program.exe"
so I needed to add quotes around the file path.
solution
shell.run chr(34) & "C:\a folder\program.exe" & chr(34)