I have a vbs file that exports three sheets as jpg images to a folder location. The vbs file makes provision for maximizing the window before exporting the images but every now and then, the image cuts off. The vbs is below. I would just like to check if there's something I can do to stop the image from cutting off on the sides.
***VBS Script***
Set MyApp = CreateObject("QlikTech.Qlikview")
Set MyDoc = MyApp.OpenDoc ("C:\Qlikview\Carl HD Monitoring\Current Helpdesk Stats.qvw")
Set ActiveDocument = MyDoc
Set Shell = WScipt.CreateObject("WScript.Shell")
ActiveDocument.Reload
ActiveDocument.Save
GraphPath = "C:\Qlikview\Carl HD Monitoring\Current_HD_Images"
Just wanted to check if anyone had an idea about my post above. I was thinking another approach could be to control the size of the image that was to be exported.
The reply was that if you are not logged on, there is no GUI for sendkeys to send keys to which will mean that every part of your script will execute perfectly except for the bit that maximizes the window. I tried a few other things which didn't work and then I found a work-around.
We have a PC that is dedicated to only reloading and displaying a slideshow of stats. I added the script to that PC which is always on and I'm logged in as the Administrator. Then I VNC in to it to make any changes necessary which is very minimal. The reason that this works is because the PC is on, with a GUI behind the slideshow that it displays which means that shell.sendkeys works 100%.
You might just have to play around with the layout of your QV document so that there is no cutoff.
