topic Copy to Excel transpose in QlikView https://community.qlik.com/t5/QlikView/Copy-to-Excel-transpose/m-p/170408#M40839 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I want to export a QV object transposed to an excel worksheet with a macro: I wrote the following test macro where first I export with send to excel and after with a past function: the oprion TRANSPOSE:= TRUE is refused by QV. Can someone help me please?</P><P><BR /> set XLApp = CreateObject("Excel.Application")<BR /> XLApp.Visible = True<BR /> set obj = ActiveDocument.getSheetObject("CH06")<BR /><BR /> obj.sendToExcel<BR /><BR /> set XLDoc = XLApp.Workbooks.item(1)<BR /><BR /><BR /> ActiveDocument.GetSheetObject("CH06").CopyTableToClipboard true<BR /> XLApp.Worksheets(1).Range("A30").Select()<BR />' XLApp.Worksheets(1).Paste()<BR /> XLApp.Worksheets(1).PasteSpecial<BR /><BR /> XLDoc.SaveAs "TEST.XLS"<BR /> 'msgbox "pause"<BR /> XLApp.Quit</P></BODY></HTML> Sun, 30 May 2010 22:11:36 GMT 2010-05-30T22:11:36Z Copy to Excel transpose https://community.qlik.com/t5/QlikView/Copy-to-Excel-transpose/m-p/170408#M40839 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I want to export a QV object transposed to an excel worksheet with a macro: I wrote the following test macro where first I export with send to excel and after with a past function: the oprion TRANSPOSE:= TRUE is refused by QV. Can someone help me please?</P><P><BR /> set XLApp = CreateObject("Excel.Application")<BR /> XLApp.Visible = True<BR /> set obj = ActiveDocument.getSheetObject("CH06")<BR /><BR /> obj.sendToExcel<BR /><BR /> set XLDoc = XLApp.Workbooks.item(1)<BR /><BR /><BR /> ActiveDocument.GetSheetObject("CH06").CopyTableToClipboard true<BR /> XLApp.Worksheets(1).Range("A30").Select()<BR />' XLApp.Worksheets(1).Paste()<BR /> XLApp.Worksheets(1).PasteSpecial<BR /><BR /> XLDoc.SaveAs "TEST.XLS"<BR /> 'msgbox "pause"<BR /> XLApp.Quit</P></BODY></HTML> Sun, 30 May 2010 22:11:36 GMT https://community.qlik.com/t5/QlikView/Copy-to-Excel-transpose/m-p/170408#M40839 2010-05-30T22:11:36Z