chart is exporting in excel with caption

Wed, 24 Sep 2014 10:57:26 GMT

Hi All,

Macro: (vb script)

set obj = ActiveDocument.GetSheetObject("CH379")

obj.CopyTableToClipboard(true)

curSheet.Range("A" & 13).Select

curSheet.Columns("A").ColumnWidth = 27

curSheet.Columns("B").ColumnWidth = 35

curSheet.Paste

This is a macro im using to export the table(straight table) to excel

my problem here is while using this above macro, my table is exporting to excel with the caption

I have 2 avoid the caption, could any one say me how to export the table without caption.

pls find the attached excel for more details

Thanks in advance

topic chart is exporting in excel with caption in QlikView