VBS : The object invoked has disconnected from its client

[#1]

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 ?

[#2]

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

[#3]

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

[#4]

Thank you very much.

I will try this out soon.