topic Re: Re: how can I send different objects  to Excel in the same page in QlikView https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728268#M261016 <HTML><HEAD></HEAD><BODY><P>Enrique Thanks a lot , but the button appears like an text object</P></BODY></HTML> Fri, 08 Aug 2014 21:39:43 GMT 2014-08-08T21:39:43Z how can I send different objects to Excel in the same page https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728260#M261008 <HTML><HEAD></HEAD><BODY><P>how can I send different objects&nbsp; to Excel in the same page,</P><P>for example if I got a 3 tables&nbsp; I need to send all to excel at the same time.</P><P></P><P></P><P>best regards.</P></BODY></HTML> Wed, 06 Aug 2014 20:57:34 GMT https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728260#M261008 2014-08-06T20:57:34Z Re: how can I send different objects to Excel in the same page https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728261#M261009 <HTML><HEAD></HEAD><BODY><P>Can you try this</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Script:</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SUB SendToExcel</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SET chart = ActiveDocument.GetSheetObject("CH01")</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SET p = chart.GetProperties</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">chart.SendToExcel</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">END SUB</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Please advise me how do i can limit the export to 'n' no. of rows.</P></BODY></HTML> Wed, 06 Aug 2014 21:02:12 GMT https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728261#M261009 ecolomer 2014-08-06T21:02:12Z Re: how can I send different objects to Excel in the same page https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728262#M261010 <HTML><HEAD></HEAD><BODY><P>Also you can use:</P><P><IMG alt="macro.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/63892_macro.png" style="width: 620px; height: 656px;" /></P></BODY></HTML> Wed, 06 Aug 2014 21:13:48 GMT https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728262#M261010 ecolomer 2014-08-06T21:13:48Z Re: how can I send different objects to Excel in the same page https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728263#M261011 <HTML><HEAD></HEAD><BODY><P>thanks a lot but, can I send this since a button?</P></BODY></HTML> Wed, 06 Aug 2014 21:29:23 GMT https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728263#M261011 2014-08-06T21:29:23Z Re: how can I send different objects  to Excel in the same page https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728264#M261012 <HTML><HEAD></HEAD><BODY><P>yes indeed </P><P>must create a macro with the editor and put on a button and run</P><P>Can help you?</P></BODY></HTML> Wed, 06 Aug 2014 21:32:18 GMT https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728264#M261012 ecolomer 2014-08-06T21:32:18Z Re: how can I send different objects to Excel in the same page https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728265#M261013 <HTML><HEAD></HEAD><BODY><P>you help me very much, thanks&nbsp; .</P><P></P><P>it Works but ,send the tables to a diferent sheet.</P><P></P><P>can I do at the same sheet?</P></BODY></HTML> Wed, 06 Aug 2014 22:21:14 GMT https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728265#M261013 2014-08-06T22:21:14Z Re: how can I send different objects  to Excel in the same page https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728266#M261014 <HTML><HEAD></HEAD><BODY><P>You can put the same name of sheet</P></BODY></HTML> Thu, 07 Aug 2014 03:23:28 GMT https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728266#M261014 ecolomer 2014-08-07T03:23:28Z Re: Re: how can I send different objects  to Excel in the same page https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728267#M261015 <HTML><HEAD></HEAD><BODY><P>I send you attached and example ...</P></BODY></HTML> Thu, 07 Aug 2014 04:05:20 GMT https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728267#M261015 ecolomer 2014-08-07T04:05:20Z Re: Re: how can I send different objects  to Excel in the same page https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728268#M261016 <HTML><HEAD></HEAD><BODY><P>Enrique Thanks a lot , but the button appears like an text object</P></BODY></HTML> Fri, 08 Aug 2014 21:39:43 GMT https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728268#M261016 2014-08-08T21:39:43Z Re: Re: Re: how can I send different objects  to Excel in the same page https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728269#M261017 <HTML><HEAD></HEAD><BODY><P>No,</P><P>The button are active and send two tables in two excel pages in the same file</P></BODY></HTML> Sat, 09 Aug 2014 03:37:06 GMT https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728269#M261017 ecolomer 2014-08-09T03:37:06Z Re: how can I send different objects to Excel in the same page https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728270#M261018 <HTML><HEAD></HEAD><BODY><P>Roldan,</P><P></P><P>Follow steps below:</P><P><BR /><A href="https://community.qlik.com/docs/DOC-3889">Export Qlikview objects to multiple Excel sheet</A></P><P><A href="https://community.qlik.com/message/544353">Re: Export to Excel - Macro</A></P><P></P><P></P><P>Thanks,<BR />AS</P></BODY></HTML> Sat, 09 Aug 2014 05:22:56 GMT https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728270#M261018 amit_saini 2014-08-09T05:22:56Z Re: Re: Re: how can I send different objects  to Excel in the same page https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728271#M261019 <HTML><HEAD></HEAD><BODY><P>thanks , in the last example I found the way.</P><P></P><P>best regards .</P><P></P><P>gracias que amables son.</P></BODY></HTML> Tue, 12 Aug 2014 16:11:02 GMT https://community.qlik.com/t5/QlikView/how-can-I-send-different-objects-to-Excel-in-the-same-page/m-p/728271#M261019 2014-08-12T16:11:02Z