topic Re: report using Macros in QlikView https://community.qlik.com/t5/QlikView/report-using-Macros/m-p/1443415#M797436 <HTML><HEAD></HEAD><BODY><P>The Macroscript opens again.</P><P>It is not opening Excel</P></BODY></HTML> Thu, 07 Dec 2017 12:15:22 GMT Anonymous 2017-12-07T12:15:22Z report using Macros https://community.qlik.com/t5/QlikView/report-using-Macros/m-p/1443410#M797431 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Is it possible to export the entire sheet to excel.</P><P></P><P>Thanks,</P><P>Dhivya</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/report-using-Macros/m-p/1443410#M797431 Anonymous 2020-11-25T16:16:04Z Re: report using Macros https://community.qlik.com/t5/QlikView/report-using-Macros/m-p/1443411#M797432 <HTML><HEAD></HEAD><BODY><P>Each report into different sheets or only one sheet with contain of all report data?</P></BODY></HTML> Thu, 07 Dec 2017 11:39:36 GMT https://community.qlik.com/t5/QlikView/report-using-Macros/m-p/1443411#M797432 Anil_Babu_Samineni 2017-12-07T11:39:36Z Re: report using Macros https://community.qlik.com/t5/QlikView/report-using-Macros/m-p/1443412#M797433 <HTML><HEAD></HEAD><BODY><P>export one report containing all the sheet objects of one sheet into a excel file</P></BODY></HTML> Thu, 07 Dec 2017 11:44:00 GMT https://community.qlik.com/t5/QlikView/report-using-Macros/m-p/1443412#M797433 Anonymous 2017-12-07T11:44:00Z Re: report using Macros https://community.qlik.com/t5/QlikView/report-using-Macros/m-p/1443413#M797434 <HTML><HEAD></HEAD><BODY><P>If moving the report is not possible</P><P>then I want to move all the sheet objects of one sheet into excel</P></BODY></HTML> Thu, 07 Dec 2017 11:45:37 GMT https://community.qlik.com/t5/QlikView/report-using-Macros/m-p/1443413#M797434 Anonymous 2017-12-07T11:45:37Z Re: report using Macros https://community.qlik.com/t5/QlikView/report-using-Macros/m-p/1443414#M797435 <HTML><HEAD></HEAD><BODY><P>May be try this?</P><P></P><P><STRONG>Sub EXPORT</STRONG></P><P><STRONG>set var = ActiveDocument.GetSheetByID("SH01").Activate</STRONG></P><P><STRONG>var.Export "Path\MyDoc.csv", ", "</STRONG></P><P><STRONG>End Sub</STRONG></P></BODY></HTML> Thu, 07 Dec 2017 11:59:50 GMT https://community.qlik.com/t5/QlikView/report-using-Macros/m-p/1443414#M797435 Anil_Babu_Samineni 2017-12-07T11:59:50Z Re: report using Macros https://community.qlik.com/t5/QlikView/report-using-Macros/m-p/1443415#M797436 <HTML><HEAD></HEAD><BODY><P>The Macroscript opens again.</P><P>It is not opening Excel</P></BODY></HTML> Thu, 07 Dec 2017 12:15:22 GMT https://community.qlik.com/t5/QlikView/report-using-Macros/m-p/1443415#M797436 Anonymous 2017-12-07T12:15:22Z