Discussion board where members can get started with QlikView.
Is it possible to create a macro to move a file to another folder from Qlikview
If so, will this work on the QV server
Use DOS command,
Maybe just use separate subfolders per day?
Let vToday = Date(Today(),'YYYY-MM-DD');
execute cmd.exe /C MKDIR "C:\QVWs\Shared Files Folder\$(vToday)";
execute cmd.exe /C MOVE "C:\QVWs\*.shared" "C:\QVWs\Shared Files Folder\$(vToday)";
Thanks. Is it possible to trigger a windows task from qlikview via a macro
That's possible with something like this:
Dim wshell As Object
wshell = CreateObject("WScript.Shell")
wshell.run("cmd /c schtasks.exe /run /TN "QlikView Tasks\ExportAndMail")
wshell = Nothing
whereby you could do it also within the load-script with an execute-statement like this:
execute schtasks.exe /Run /TN "QlikView Tasks\ExportAndMail";
which could be triggerred from the qmc in opposite to a macro.