Macro to run exe

Thu, 09 Sep 2010 21:57:06 GMT

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

Macro to run exe

Thu, 09 Sep 2010 22:17:35 GMT

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)

topic Macro to run exe in QlikView

Macro to run exe

Macro to run exe