Get an object from other Qlik document in VB module

[christian77]

Hi:

I need to get an object from another document. Instead of ActiveDocument.GetSheetObject("CH01"),
OtherDocument.GetSheetObject.

Does anybody know the syntax?

Thanks.

[imrencimen]

Did you solve it??

[marcus_sommer]

You need to open and to instantiate the new app and then you could access the objects. Here a small example:

set newApp = ActiveDocument.GetApplication

set newdoc = newApp.OpenDoc (path & QVW_file,"","")

and then:

newdoc.Fields("Month").Select month(now() - 1)

set ex = newdoc.GetSheetObject("CH10029")

....

- Marcus

[tamilarasu]

Hi Imren,

What is your exact requirement.?

[imrencimen]

ı want to prepeare a dashboard pdf which has charts from different qvw objects.

dail_ product_report

sales_report

notdelivered_products etc..

all raports have a dashboard. I want to bring selected charts together (which are from other tree QVW)

--(without data-only visually)  and export to pdf od ppt then send to email.

How can I do this with macro?