Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day,
I want to make a script that makes exports (XLS, PNG, PDF) of QV graphs.
As Server/Publisher don't execute macro, I've written the following "export.vbs":
Set MyApp = CreateObject("QlikTech.QlikView")
Set MyDoc = MyApp.OpenDoc ("C:\QV docs\export.qvw","","")
set obj = MyDoc.GetSheetObject("GR_01")
obj.exportbitmaptofile("C:\QV cible\export.png")
where "GR_01" is the graph I want to export.
When I execute the script, I have the following message :
I tried many things (use the ".press" function on a button, etc...) but I always have this "The object invoked has disconnected".
Do I missed something ?
Hi nmartin,
i want to do the same. Create an excel file of an special table in a QlikView document.
Where you have written the macro, and where can I execute this macro? Do I need an external task or how you solved this?
Thanks!
Regards,
Andreas
I've created a file named "export.vbs". I've edited it with a simple notepad.
You can execute it by double click, or by command line :
C:\Windows\System32\cscript.exe C:\tmp\export.vbs
Thank you very much.
I will try this out soon.