<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re. :table.CopyTableToClipboard question in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/table-CopyTableToClipboard-question/m-p/153263#M30368</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;/P&gt;&lt;DIV&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;Could you send a part of your QV application for testing.&lt;/P&gt;&lt;/DIV&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 09 Aug 2010 15:05:50 GMT</pubDate>
    <dc:creator>martin59</dc:creator>
    <dc:date>2010-08-09T15:05:50Z</dc:date>
    <item>
      <title>table.CopyTableToClipboard question</title>
      <link>https://community.qlik.com/t5/QlikView/table-CopyTableToClipboard-question/m-p/153262#M30367</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;see code below&lt;/P&gt;&lt;P&gt;this gives me this result:&lt;/P&gt;&lt;P&gt;11111&lt;/P&gt;&lt;P&gt;XXXX 22222&lt;/P&gt;&lt;P&gt;33333&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;but i want&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;XXXXX 111111&lt;/P&gt;&lt;P&gt;XXXXX 222222&lt;/P&gt;&lt;P&gt;XXXXX 333333&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;this is the same result that i have with Send to Excel&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"&gt;&lt;BR /&gt; XLApp.Visible = True&lt;BR /&gt;&lt;BR /&gt; 'set XLSheet = XLDoc.Worksheets(TabNumber)&lt;BR /&gt; set XLSheet = XLDoc.Worksheets.Add&lt;BR /&gt; XLSheet.Activate&lt;BR /&gt;&lt;BR /&gt; set table = ActiveDocument.GetSheetObject(SheetObject)&lt;BR /&gt;&lt;BR /&gt; table.CopyTableToClipboard false 'Copy data to Clipboard&lt;BR /&gt; XLSheet.Paste XLSheet.Range("A1") 'Paste data into cell&lt;BR /&gt;&lt;BR /&gt; XLSheet.Cells.WrapText = False&lt;BR /&gt;&lt;BR /&gt; XLsheet.Cells.select&lt;BR /&gt; XLsheet.Cells.EntireColumn.AutoFit&lt;BR /&gt;&lt;BR /&gt; XLSheet.Rows("1:1").Select&lt;BR /&gt; XLSheet.Cells.AutoFilter&lt;BR /&gt; XLsheet.name = TabText&lt;BR /&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt; &lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 09 Aug 2010 14:02:13 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/table-CopyTableToClipboard-question/m-p/153262#M30367</guid>
      <dc:creator>amien</dc:creator>
      <dc:date>2010-08-09T14:02:13Z</dc:date>
    </item>
    <item>
      <title>Re. :table.CopyTableToClipboard question</title>
      <link>https://community.qlik.com/t5/QlikView/table-CopyTableToClipboard-question/m-p/153263#M30368</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;/P&gt;&lt;DIV&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;Could you send a part of your QV application for testing.&lt;/P&gt;&lt;/DIV&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 09 Aug 2010 15:05:50 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/table-CopyTableToClipboard-question/m-p/153263#M30368</guid>
      <dc:creator>martin59</dc:creator>
      <dc:date>2010-08-09T15:05:50Z</dc:date>
    </item>
  </channel>
</rss>

