Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

getting error 'Paste method of Worksheet class failed'

Hi,

My Macro creates an Excel file and copies data from one of the table objects to the Excel Sheet.

set MyTable = ActiveDocument.GetSheetObject("CH551")
set XLSheet = XLDoc.Worksheets(1)
MyTable.CopyTableToClipboard true
XLSheet.Paste XLSheet.Range("B" & MaxRowCnt)

I am getting an error 'Paste method of Worksheet class failed'.

please help

Community Browser