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
