Automated Export (Macro) to Excel not working in Windows 2016 QV12
I am unable to get a macro to run through QMC or Windows Task Scheduler after the server was upgraded to Windows 2016 and QlikView 12. The macro works perfectly when running manually from QlikView Desktop but does not run at all when the qvw is refreshed through QMC or using a batch file and Windows Task Scheduler. Does anybody have any solutions or ideas?
I had the same problem. As far as I know QMC cannot automatically fire QVW macros. Another problem is: the service user (running automatically) can neither user Excel.Application nor simulate it - that is why any vbs batch file will fail.
What I used is the following:
- store your data from QVW to CSVs automatically (via QMC task).
- create 2 PowerShell scripts (one to copy all your CSV files and store them into 1 xlsx file) and anothter to delete the xlsx file when it is not needed anymore.
- automate these 2 PowerShell scripts via MS Windows Task Manager.