topic Opening an excel document in QlikView https://community.qlik.com/t5/QlikView/Opening-an-excel-document/m-p/158932#M505080 <HTML><HEAD></HEAD><BODY><P>Hy amar,</P><P>you could do it this way:</P><P></P><P>Set objExcel = CreateObject("EXCEL.APPLICATION")<BR />Set objWorkBook = objExcel.Workbooks.Open(reportFile)<BR />objExcel.Visible = True</P><P></P><P>Rgds,<BR />Joachim</P><BR /><BR /></BODY></HTML> Mon, 17 Aug 2009 20:12:33 GMT biester 2009-08-17T20:12:33Z Opening an excel document https://community.qlik.com/t5/QlikView/Opening-an-excel-document/m-p/158931#M505079 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I am exporting an excel sheet using a macro like this</P><P></P><P>set obj = ActiveDocument.GetSheetObject(ExcelID)</P><P>obj.ExportBiff reportFile &amp; ".xls"</P><P>reportFile = reportFile &amp; ".xls"</P><DIV>I want to open the excel file after it is being exported. How to do it in a macro?</DIV><DIV>Thanks in advance</DIV><DIV></DIV><DIV>Regards</DIV><DIV>Amar</DIV><BR /><BR /></BODY></HTML> Mon, 17 Aug 2009 19:27:13 GMT https://community.qlik.com/t5/QlikView/Opening-an-excel-document/m-p/158931#M505079 amars 2009-08-17T19:27:13Z Opening an excel document https://community.qlik.com/t5/QlikView/Opening-an-excel-document/m-p/158932#M505080 <HTML><HEAD></HEAD><BODY><P>Hy amar,</P><P>you could do it this way:</P><P></P><P>Set objExcel = CreateObject("EXCEL.APPLICATION")<BR />Set objWorkBook = objExcel.Workbooks.Open(reportFile)<BR />objExcel.Visible = True</P><P></P><P>Rgds,<BR />Joachim</P><BR /><BR /></BODY></HTML> Mon, 17 Aug 2009 20:12:33 GMT https://community.qlik.com/t5/QlikView/Opening-an-excel-document/m-p/158932#M505080 biester 2009-08-17T20:12:33Z