Discussion Board for collaboration related to QlikView App Development.
Hey hi guys,
I'm trying to run a little batch file via macro, and it works just fine... BUT it doesn't when running server side...
Set objshell = createobject("Wscript.Shell")
sCmd = Chr(34) & "C:\batch.bat " & Chr(34)
objshell.Run(sCmd), 0, False
Thanks a bunch!
[quote user="Nicolas Dubé"]running the batch file located on the server C driver, not the user C drive
Does the batch file need to actually *execute* on the server, or can you run on the client but use a UNC path -- \\server\folder\batch.bat -- to point to the file on the server.
I once had the same problem due to the fact that we don't have the publisher enterprise, but the standard edtion.
The only solution I found was the following:
- Creating a dummy file server side with serversideexport (s. manual/API)
- Running a script/ program which observes the folder all the time and which executes your batch in case of a filled folder
- Delete the file
But maybe s.o. knows a better solution...
Rob, well yes, it actually has to RUN on the server since the batch file uses a special program that we don't want to install client side. That's the real itching point here.
DW, that's a concept, thanks for the idea, this might work as a last resort, but a more straightforward solution would be appreciated here, since this is tied up to the end user response time.