getting error 'Paste method of Worksheet class failed'

[#1]

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