topic Re: Macro to move file to another folder in QlikView

Macro to move file to another folder

Wed, 25 Nov 2020 16:16:04 GMT

Hi all

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

Regards

koushik_btech20 — Wed, 04 Jan 2017 08:36:01 GMT

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)";

Fri, 06 Jan 2017 11:00:17 GMT

Thanks. Is it possible to trigger a windows task from qlikview via a macro

marcus_sommer — Fri, 06 Jan 2017 12:41:23 GMT

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.

- Marcus