<?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 Save Workbook MS Excel in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Save-Workbook-MS-Excel/m-p/82562#M33968</link>
    <description>&lt;P&gt;&lt;SPAN&gt;I have a problem saving my collection to Excel.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;My collection looks like this:&lt;/SPAN&gt;&lt;BR /&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="23575.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/23709iC06D74D6292F6443/image-size/large?v=v2&amp;amp;px=999" role="button" title="23575.png" alt="23575.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&lt;/P&gt;
&lt;P&gt;And my&lt;SPAN&gt; logic in Blue Prism looks like this: &lt;span class="lia-inline-image-display-wrapper" image-alt="23576.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/23710i4C62F2128EF2A88F/image-size/large?v=v2&amp;amp;px=999" role="button" title="23576.png" alt="23576.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Workbook Name is the same as the name of Excel file:&lt;BR /&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="23577.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/23708iB7259359863D9F6B/image-size/large?v=v2&amp;amp;px=999" role="button" title="23577.png" alt="23577.png" /&gt;&lt;/span&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="23578.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/23711iABE24621A0628DC4/image-size/large?v=v2&amp;amp;px=999" role="button" title="23578.png" alt="23578.png" /&gt;&lt;/span&gt; &lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;When I click 'step over,' everything looks fine, and the collection is written to Excel. However, when I start the robot from the beginning, it doesn't work.&lt;BR /&gt;&lt;BR /&gt;How to solve this problem?&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;/P&gt;&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;BR /&gt;Norbert Florczak&lt;BR /&gt;------------------------------&lt;BR /&gt;</description>
    <pubDate>Sat, 24 Feb 2024 14:37:00 GMT</pubDate>
    <dc:creator>bazygon</dc:creator>
    <dc:date>2024-02-24T14:37:00Z</dc:date>
    <item>
      <title>Save Workbook MS Excel</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Save-Workbook-MS-Excel/m-p/82562#M33968</link>
      <description>&lt;P&gt;&lt;SPAN&gt;I have a problem saving my collection to Excel.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;My collection looks like this:&lt;/SPAN&gt;&lt;BR /&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="23575.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/23709iC06D74D6292F6443/image-size/large?v=v2&amp;amp;px=999" role="button" title="23575.png" alt="23575.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&lt;/P&gt;
&lt;P&gt;And my&lt;SPAN&gt; logic in Blue Prism looks like this: &lt;span class="lia-inline-image-display-wrapper" image-alt="23576.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/23710i4C62F2128EF2A88F/image-size/large?v=v2&amp;amp;px=999" role="button" title="23576.png" alt="23576.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Workbook Name is the same as the name of Excel file:&lt;BR /&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="23577.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/23708iB7259359863D9F6B/image-size/large?v=v2&amp;amp;px=999" role="button" title="23577.png" alt="23577.png" /&gt;&lt;/span&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="23578.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/23711iABE24621A0628DC4/image-size/large?v=v2&amp;amp;px=999" role="button" title="23578.png" alt="23578.png" /&gt;&lt;/span&gt; &lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;When I click 'step over,' everything looks fine, and the collection is written to Excel. However, when I start the robot from the beginning, it doesn't work.&lt;BR /&gt;&lt;BR /&gt;How to solve this problem?&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;/P&gt;&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;BR /&gt;Norbert Florczak&lt;BR /&gt;------------------------------&lt;BR /&gt;</description>
      <pubDate>Sat, 24 Feb 2024 14:37:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Save-Workbook-MS-Excel/m-p/82562#M33968</guid>
      <dc:creator>bazygon</dc:creator>
      <dc:date>2024-02-24T14:37:00Z</dc:date>
    </item>
    <item>
      <title>RE: Save Workbook MS Excel</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Save-Workbook-MS-Excel/m-p/82563#M33969</link>
      <description>&lt;DIV class="flex flex-grow flex-col max-w-full"&gt;
&lt;DIV data-message-author-role="assistant" data-message-id="c9735d47-bf35-491b-a031-848df3360a2d" class="min-h-[20px] text-message flex flex-col items-start gap-3 whitespace-pre-wrap break-words [.text-message+&amp;amp;]:mt-5 overflow-x-auto"&gt;
&lt;DIV class="markdown prose w-full break-words dark:prose-invert light"&gt;
&lt;P&gt;Hello Norbert,&lt;/P&gt;
&lt;P&gt;Could you avoid using "Close All Instances"? I believe the bot is encountering a common error "RPC Server Is Unavailable (Exception from HRESULT: 0x800706BA)"(Please visit the support center &lt;A href="https://support.blueprism.com/en/support/solutions/articles/7000076778-windows-error-rpc-server-is-unavailable-exception-from-hresult-0x800706ba-"&gt;RPC Server is Unavailable&lt;/A&gt;) when running at full speed. Although running step by step works fine, please be cautious, as the "Close All Instances" action may lead to this error occurring sooner or later.&lt;/P&gt;
&lt;P&gt;Instead, you should use "Close Instance" and always ensure that when you finish working with that Excel file, you close the instance.&amp;nbsp;&lt;/P&gt;
&lt;DIV class="flex flex-grow flex-col max-w-full"&gt;
&lt;DIV data-message-author-role="assistant" data-message-id="d04f6204-a6e0-4004-afd0-95cde7dd9036" class="min-h-[20px] text-message flex flex-col items-start gap-3 whitespace-pre-wrap break-words [.text-message+&amp;amp;]:mt-5 overflow-x-auto"&gt;
&lt;DIV class="markdown prose w-full break-words dark:prose-invert light"&gt;
&lt;P&gt;On the other hand, the exception handling doesn't look good. Consider if the process fails at any point within that block, it will retry three times. This could lead to the "Open Workbook" action attempting to open a workbook that is already open.&lt;/P&gt;
&lt;P&gt;If it fails, the instance needs to be closed (or not, depending on the type of solution). You could use "Close All Instances" within a single block with a recovery stage followed by the "Utility Environment: Kill Process" action, specifying the "excel" process to terminate it.&lt;/P&gt;
&lt;P&gt;Hope it helps, regards!&lt;/P&gt;
&lt;P&gt;&lt;/P&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;/P&gt;
&lt;P&gt;If this was helpful, please mark it as the best answer &lt;span class="lia-unicode-emoji" title=":slightly_smiling_face:"&gt;🙂&lt;/span&gt;&lt;BR /&gt;Daniel Sanhueza&lt;BR /&gt;RPA Professional Developer&lt;BR /&gt;Deloitte&lt;BR /&gt;America/Santiago&lt;BR /&gt;------------------------------&lt;BR /&gt;&lt;/P&gt;</description>
      <pubDate>Sat, 24 Feb 2024 23:26:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Save-Workbook-MS-Excel/m-p/82563#M33969</guid>
      <dc:creator>Daniel_Sanhueza</dc:creator>
      <dc:date>2024-02-24T23:26:00Z</dc:date>
    </item>
  </channel>
</rss>

