topic getting error 'Paste method of Worksheet class failed' in QlikView https://community.qlik.com/t5/QlikView/getting-error-Paste-method-of-Worksheet-class-failed/m-p/151390#M1310678 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>My Macro creates an Excel file and copies data from one of the table objects to the Excel Sheet.</P><P>set MyTable = ActiveDocument.GetSheetObject("CH551")<BR /> set XLSheet = XLDoc.Worksheets(1)<BR /> MyTable.CopyTableToClipboard true<BR /> XLSheet.Paste XLSheet.Range("B" &amp; MaxRowCnt)</P><P>I am getting an error 'Paste method of Worksheet class failed'.</P><P>please help</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT 2026-01-26T18:19:17Z getting error 'Paste method of Worksheet class failed' https://community.qlik.com/t5/QlikView/getting-error-Paste-method-of-Worksheet-class-failed/m-p/151390#M1310678 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>My Macro creates an Excel file and copies data from one of the table objects to the Excel Sheet.</P><P>set MyTable = ActiveDocument.GetSheetObject("CH551")<BR /> set XLSheet = XLDoc.Worksheets(1)<BR /> MyTable.CopyTableToClipboard true<BR /> XLSheet.Paste XLSheet.Range("B" &amp; MaxRowCnt)</P><P>I am getting an error 'Paste method of Worksheet class failed'.</P><P>please help</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/getting-error-Paste-method-of-Worksheet-class-failed/m-p/151390#M1310678 2026-01-26T18:19:17Z