topic Get an object from other Qlik document in VB module in QlikView https://community.qlik.com/t5/QlikView/Get-an-object-from-other-Qlik-document-in-VB-module/m-p/634105#M232588 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P>I need to get an object from another document. Instead of ActiveDocument.GetSheetObject("CH01"), <BR />OtherDocument.GetSheetObject.</P><P></P><P>Does anybody know the syntax?</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 30 May 2014 12:00:26 GMT christian77 2014-05-30T12:00:26Z Get an object from other Qlik document in VB module https://community.qlik.com/t5/QlikView/Get-an-object-from-other-Qlik-document-in-VB-module/m-p/634105#M232588 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P>I need to get an object from another document. Instead of ActiveDocument.GetSheetObject("CH01"), <BR />OtherDocument.GetSheetObject.</P><P></P><P>Does anybody know the syntax?</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 30 May 2014 12:00:26 GMT https://community.qlik.com/t5/QlikView/Get-an-object-from-other-Qlik-document-in-VB-module/m-p/634105#M232588 christian77 2014-05-30T12:00:26Z Re: Get an object from other Qlik document in VB module https://community.qlik.com/t5/QlikView/Get-an-object-from-other-Qlik-document-in-VB-module/m-p/634106#M232589 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Did you solve it</SPAN>??</P></BODY></HTML> Mon, 04 Apr 2016 11:48:05 GMT https://community.qlik.com/t5/QlikView/Get-an-object-from-other-Qlik-document-in-VB-module/m-p/634106#M232589 imrencimen 2016-04-04T11:48:05Z Re: Get an object from other Qlik document in VB module https://community.qlik.com/t5/QlikView/Get-an-object-from-other-Qlik-document-in-VB-module/m-p/634107#M232590 <HTML><HEAD></HEAD><BODY><P>You need to open and to instantiate the new app and then you could access the objects. Here a small example:</P><P></P><P>set newApp = ActiveDocument.GetApplication</P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">set newdoc = newApp.OpenDoc (path &amp; QVW_file,"","")</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><BR /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">and then:</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><BR /></SPAN></P><P>newdoc.Fields("Month").Select month(now() - 1)</P><P>set ex = newdoc.GetSheetObject("CH10029")</P><P>....</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 04 Apr 2016 13:47:38 GMT https://community.qlik.com/t5/QlikView/Get-an-object-from-other-Qlik-document-in-VB-module/m-p/634107#M232590 marcus_sommer 2016-04-04T13:47:38Z Re: Get an object from other Qlik document in VB module https://community.qlik.com/t5/QlikView/Get-an-object-from-other-Qlik-document-in-VB-module/m-p/634108#M232591 <HTML><HEAD></HEAD><BODY><P>Hi Imren,</P><P></P><P>What is your exact requirement.? </P></BODY></HTML> Mon, 04 Apr 2016 13:52:53 GMT https://community.qlik.com/t5/QlikView/Get-an-object-from-other-Qlik-document-in-VB-module/m-p/634108#M232591 tamilarasu 2016-04-04T13:52:53Z Re: Get an object from other Qlik document in VB module https://community.qlik.com/t5/QlikView/Get-an-object-from-other-Qlik-document-in-VB-module/m-p/634109#M232592 <HTML><HEAD></HEAD><BODY><P>ı want to prepeare a dashboard pdf which has charts from different <SPAN style="font-size: 13.3333px;">qvw <SPAN style="font-size: 13.3333px;">objects.</SPAN></SPAN></P><P></P><P>dail_ product_report</P><P>sales_report</P><P>notdelivered_products etc..</P><P></P><P>all raports have a dashboard. I want to bring <SPAN style="font-size: 13.3333px;">selected charts <SPAN style="font-size: 13.3333px;">together (</SPAN>which are from other tree QVW) </SPAN></P><P>--(without data-only <SPAN lang="en">visually</SPAN>)&nbsp; and export to pdf od ppt then send to email.</P><P></P><P>How can I do this with macro?</P></BODY></HTML> Mon, 04 Apr 2016 14:18:42 GMT https://community.qlik.com/t5/QlikView/Get-an-object-from-other-Qlik-document-in-VB-module/m-p/634109#M232592 imrencimen 2016-04-04T14:18:42Z