Automate daily macro

Wed, 22 Feb 2017 11:45:28 GMT

I would like to keep open a Qlik desktop so the below can be automated to run at 08:00 every day.

Is this possible please ?

Sub ExportToFile

vStamp = ActiveDocument.Evaluate("TimeStamp(Now(),'YYYYMMDDhhmm')")

vToday = ActiveDocument.Evaluate("TimeStamp(Now(),'YYYYMMDD')")

set sObject = ActiveDocument.GetSheetObject("SoOpen")

sObject.Export "\\Upload\OpenSalesOrders_" & vStamp & ".csv", ", "

End Sub

Re: Automate daily macro

Anonymous — Wed, 22 Feb 2017 11:52:04 GMT

You can use a windows scheduled task to run the document from the command line where ** is you document path e.g.;

C:\Program Files\QlikView\qv.exe *C:\Users\gwilson\Documents\Qlik\DateTime.qvw*

Then in the Document Properties of your document you can use an OnOpen Trigger to run the macro