Dimension labels coming after checking suppress header when export

sivarajs — Tue, 23 Jun 2015 13:18:24 GMT

Hi,

I have a straight table which have checked suppress header row. I am exporting the table to word document. After exporting to the dimension labels are coming in the word document which i don't want.

Code:

Sub export_word

set objWord = CreateObject("Word.Application")

objWord.visible = false

set objDoc=objWord.Documents.add

Const wdOrientLandscape = 0

objDoc.PageSetup.Orientation = wdOrientLandscape

ActiveDocument.GetSheetObject("CH02").CopyTableToClipboard true

objWord.Selection.Paste

objSelection.TypeText chr(11)

ActiveDocument.GetSheetObject("CH04").CopyTableToClipboard true

objWord.Selection.Paste

objSelection.TypeText chr(11)

ActiveDocument.GetSheetObject("CH01").CopyTableToClipboard true

objWord.Selection.Paste

'objDoc.SaveAs "C:\Report"

objWord.quit

end sub

Regards,

Sivaraj

Re: Dimension labels coming after checking suppress header when export

giakoum — Tue, 23 Jun 2015 13:21:23 GMT

maybe this helps

Re: Export chart to delimited file using any delimiter and removing headers

Re: Dimension labels coming after checking suppress header when export

sivarajs — Tue, 23 Jun 2015 13:49:40 GMT

Actually am exporting many tables to word. But i want only specific object without header when export.

topic Re: Dimension labels coming after checking suppress header when export in QlikView

Dimension labels coming after checking suppress header when export

Re: Dimension labels coming after checking suppress header when export

Re: Dimension labels coming after checking suppress header when export