Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a macro imbedded in a QlikView dashboard, which I have set a trigger task to run on reload. This works when reloading it manually, but doesn't work when scheduled on QMC. I have also tried running this macro on NPrinting v16, as a run macro task and reload task, but again it runs when I execute manually but doesn't run on the schedule.
The macro is below -
---------------------------------------------
sub ExportReport
v = ActiveDocument.Evaluate("=timestamp(today(),'YYYYMMDD')")
ActiveDocument.Variables("vDate").SetContent v, true
set obj = ActiveDocument.GetSheetObject("CH03")
obj.exportex ActiveDocument.Variables("vQVDCommon").GetContent.String &"\PricingProduction_"& ActiveDocument.Variables("vDate").GetContent.String &".qvd",4
end sub
---------------------------------------------
I have read that macros don't run on QMC and need a batch file to open the dashboard and reload. This is something I have never done before and wouldn't know where to start. Please can you help to automate this process.
Many thanks,
John