Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Usset Qv = CreateObject("QlikTech.QlikView") Set DocObj = Qv.OpenDoc ("c:\my_document.qvw","","") DocObj.ClearAll false DocObj.GetSheetObject("BU01").Press WScript.Sleep 5000 Set DocObj = Nothing Qv.quit Set Qv = Nothing
The batch file executes fine when run from by a user from the command prompt.
When run from a Publisher supporting task, the task never finishes. From the task manager it can be seen that the task started a QV.exe process, but this process never ends.
The vbs script runs QlikView and the QlikView settings are being read from:
C:\Users\ < User Name >\AppData\Roaming\QlikTech\QlikView\Settings.ini
Since the service has never answered any dialog pages about allowing macros, there will be no information in this settings.ini about macro security preferences. So when the task gets run, and the vbs script opens the QlikView document, the process hangs at the stage of QlikView asking about the macro security preferences. Since the Service runs without GUI we never see this message box and the Qv.exe process apears to have hung.
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join UsSearch Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a caseExperiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us