<?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: getting the below error when tring to export data from qlikview application in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/getting-the-below-error-when-tring-to-export-data-from-qlikview/m-p/658426#M240278</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have the same error.&lt;/P&gt;&lt;P&gt;The ExportToExcel macro worked for Excel 2010 and ,now, it does not work for Excel2013.&lt;/P&gt;&lt;P&gt;Any idea on how to solve this?&lt;/P&gt;&lt;P&gt;Or any suggestions on what it is different in Excel 2013 that could effect the macro function?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Cristina Jianu&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 21 Oct 2014 10:05:52 GMT</pubDate>
    <dc:creator />
    <dc:date>2014-10-21T10:05:52Z</dc:date>
    <item>
      <title>getting the below error when tring to export data from qlikview application</title>
      <link>https://community.qlik.com/t5/QlikView/getting-the-below-error-when-tring-to-export-data-from-qlikview/m-p/658422#M240274</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi All ,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I am getting the below error when tring to export data from qlikview application , Can anyone please advice me how do i resolve the issue.its urgent&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;Macro Parse Failed : functionality was lost&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Export2XL_Multisheet&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Error :subscript out of range&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 11 Jun 2014 12:14:18 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/getting-the-below-error-when-tring-to-export-data-from-qlikview/m-p/658422#M240274</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2014-06-11T12:14:18Z</dc:date>
    </item>
    <item>
      <title>Re: getting the below error when tring to export data from qlikview application</title>
      <link>https://community.qlik.com/t5/QlikView/getting-the-below-error-when-tring-to-export-data-from-qlikview/m-p/658423#M240275</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;What does your macro look like?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 11 Jun 2014 15:50:06 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/getting-the-below-error-when-tring-to-export-data-from-qlikview/m-p/658423#M240275</guid>
      <dc:creator>m_woolf</dc:creator>
      <dc:date>2014-06-11T15:50:06Z</dc:date>
    </item>
    <item>
      <title>Re: getting the below error when tring to export data from qlikview application</title>
      <link>https://community.qlik.com/t5/QlikView/getting-the-below-error-when-tring-to-export-data-from-qlikview/m-p/658424#M240276</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Do you used macro to export Excel or you directly export.&lt;/P&gt;&lt;P&gt;Can you post your macro here.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;P&gt;ASHFAQ&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 11 Jun 2014 17:18:59 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/getting-the-below-error-when-tring-to-export-data-from-qlikview/m-p/658424#M240276</guid>
      <dc:creator>ashfaq_haseeb</dc:creator>
      <dc:date>2014-06-11T17:18:59Z</dc:date>
    </item>
    <item>
      <title>Re: getting the below error when tring to export data from qlikview application</title>
      <link>https://community.qlik.com/t5/QlikView/getting-the-below-error-when-tring-to-export-data-from-qlikview/m-p/658425#M240277</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;you can use this macro for export.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;OL class="dp-xml" start="1" style="font-size: 12px; font-family: Consolas, 'Courier New', Courier, mono, serif; list-style-position: initial; list-style-image: initial; color: #5c5c5c; margin-bottom: 1px !important; margin-left: 45px !important;"&gt;&lt;LI&gt;&lt;SPAN style="color: black; font-size: 9pt !important; font-style: inherit; background-color: inherit; font-weight: inherit;"&gt;sub Export&amp;nbsp; &lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; set &lt;SPAN class="attribute" style="font-weight: inherit; font-style: inherit; color: red; font-size: 9pt !important; background-color: inherit;"&gt;XLApp&lt;/SPAN&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"&gt; = &lt;/SPAN&gt;&lt;SPAN class="attribute-value" style="font-weight: inherit; font-style: inherit; color: blue; font-size: 9pt !important; background-color: inherit;"&gt;CreateObject&lt;/SPAN&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"&gt;("Excel.Application") ' Define Object&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;SPAN class="attribute" style="font-weight: inherit; font-style: inherit; color: red; font-size: 9pt !important; background-color: inherit;"&gt;XLApp.Visible&lt;/SPAN&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"&gt; = &lt;/SPAN&gt;&lt;SPAN class="attribute-value" style="font-weight: inherit; font-style: inherit; color: blue; font-size: 9pt !important; background-color: inherit;"&gt;True&lt;/SPAN&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"&gt; 'Visible set as true&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; set &lt;SPAN class="attribute" style="font-weight: inherit; font-style: inherit; color: red; font-size: 9pt !important; background-color: inherit;"&gt;XLDoc&lt;/SPAN&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"&gt; = &lt;/SPAN&gt;&lt;SPAN class="attribute-value" style="font-weight: inherit; font-style: inherit; color: blue; font-size: 9pt !important; background-color: inherit;"&gt;XLApp&lt;/SPAN&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"&gt;.Workbooks.Add 'Open new workbook&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; set &lt;SPAN class="attribute" style="font-weight: inherit; font-style: inherit; color: red; font-size: 9pt !important; background-color: inherit;"&gt;table&lt;/SPAN&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"&gt; = &lt;/SPAN&gt;&lt;SPAN class="attribute-value" style="font-weight: inherit; font-style: inherit; color: blue; font-size: 9pt !important; background-color: inherit;"&gt;ActiveDocument&lt;/SPAN&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"&gt;.GetSheetObject("TB04")&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; rem set &lt;SPAN class="attribute" style="font-weight: inherit; font-style: inherit; color: red; font-size: 9pt !important; background-color: inherit;"&gt;table&lt;/SPAN&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"&gt; = &lt;/SPAN&gt;&lt;SPAN class="attribute-value" style="font-weight: inherit; font-style: inherit; color: blue; font-size: 9pt !important; background-color: inherit;"&gt;ActiveDocument&lt;/SPAN&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"&gt;.GetSheetObject("MB01")&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; set &lt;SPAN class="attribute" style="font-weight: inherit; font-style: inherit; color: red; font-size: 9pt !important; background-color: inherit;"&gt;XLSheet&lt;/SPAN&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"&gt; = &lt;/SPAN&gt;&lt;SPAN class="attribute-value" style="font-weight: inherit; font-style: inherit; color: blue; font-size: 9pt !important; background-color: inherit;"&gt;XLDoc&lt;/SPAN&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"&gt;.Worksheets(1) 'Select sheet where data should be pasted&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; table.CopyTableToClipboard true 'Copy data to Clipboard&amp;nbsp; &lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; XLSheet.Paste XLSheet.Range("A1") 'Paste data into cell&amp;nbsp; &lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;"&gt;end sub&amp;nbsp; &lt;/SPAN&gt;&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;P&gt;ASHFAQ&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 11 Jun 2014 17:20:56 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/getting-the-below-error-when-tring-to-export-data-from-qlikview/m-p/658425#M240277</guid>
      <dc:creator>ashfaq_haseeb</dc:creator>
      <dc:date>2014-06-11T17:20:56Z</dc:date>
    </item>
    <item>
      <title>Re: getting the below error when tring to export data from qlikview application</title>
      <link>https://community.qlik.com/t5/QlikView/getting-the-below-error-when-tring-to-export-data-from-qlikview/m-p/658426#M240278</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have the same error.&lt;/P&gt;&lt;P&gt;The ExportToExcel macro worked for Excel 2010 and ,now, it does not work for Excel2013.&lt;/P&gt;&lt;P&gt;Any idea on how to solve this?&lt;/P&gt;&lt;P&gt;Or any suggestions on what it is different in Excel 2013 that could effect the macro function?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Cristina Jianu&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 21 Oct 2014 10:05:52 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/getting-the-below-error-when-tring-to-export-data-from-qlikview/m-p/658426#M240278</guid>
      <dc:creator />
      <dc:date>2014-10-21T10:05:52Z</dc:date>
    </item>
  </channel>
</rss>

