I have a Button in a QVW which executes a Macro successfully to generate email. I have to open the QVW, Click the Button once (executes Macro) and the Email will come in Outlook.
But I tried using the OnPostReload and OnOpen triggers but unfortunately Macro never works in that. So doing every day manually to click the button to get the output.
Is there any way, any batch script or any task that can click the Button in the QVW automatically at a desired time period?
Any suggestions are welcome!
Thanks for suggestion.
I had never used Excel Macros to control Qlik, but surely will give it a try.
I believe again that will be a manual task to Run Excel Macros?
- Create a Vba code to open Qlik Document. (Sample of QlikView automation by external VBScript scripts · blog.infovizion.ru)
- Perform Required operations.
Note: You can try auto scheduling the vba script. (.vbs file)
Great help buddy!
Now I can use the VBS to Open a QVW and some small desired actions.
Can you provide some more help in how and where to automate my VBS Script?
Best way to trigger VBA script on particular time is through windows task.
Create a task to execute vbs file and schedule it in windows as per your requirement.
VBS file is scheduled and running as per triggered schedule. But it's really not opening up the QVW.
However the VBS logs shows no error. When run from local, it opens up the QVW, but not through scheduler.
Note - My QVW is in SAN drive.
I was able to achieve this using a Batch Script that runs as Trigger in Windows Scheduler.
But I will still work, why its not working in VBS while reloaded as Trigger.
Thanks again for the suggestions.
As of now, only for this particular QVW to fulfill the requirement.
An Open command/scheduler to open the QV.exe and the desired App-
"C:\Program Files\QlikView\QV.exe" "YoyrPath\YourApp.qvw" >> openlog.txt exit
A close command/scheduler with to close the QV.exe to save memory in Task Manager-
taskkill /f /IM E:\Program Files\QlikView\QV.exe >> log.txt
This helps the requirement at least.