0 Replies Latest reply: Sep 8, 2010 3:20 AM by Kishori Gaikwad RSS

    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