<?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: Save workbook as with password in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Save-workbook-as-with-password/m-p/66093#M18698</link>
    <description>The MS Excel VBO has an action for this, it's called "Protect Workbook". You can pass the password and the workbook that you want to protect. ​However, if you want more functionalities, like specifying what you want to lock (like formatting, column width....) you will have to create your own action.&lt;BR /&gt;&lt;BR /&gt;If you are asking, how to unprotect a file and then save it without a password, Blue Prism doesn't have an out of the box object for that. You can achieve it either creating an object that interacts with Excel UI (not recommended considering that the UI might change with new versions of Excel) or you can create your own code.&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;BR /&gt;Melissa G.&lt;BR /&gt;America/New_York&lt;BR /&gt;------------------------------&lt;BR /&gt;</description>
    <pubDate>Wed, 12 Jun 2019 20:50:00 GMT</pubDate>
    <dc:creator>MelissaSuarez_G</dc:creator>
    <dc:date>2019-06-12T20:50:00Z</dc:date>
    <item>
      <title>Save workbook as with password</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Save-workbook-as-with-password/m-p/66090#M18695</link>
      <description>I want to save workbook with password.

could any one let me know the code for this</description>
      <pubDate>Tue, 08 Jan 2019 17:34:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Save-workbook-as-with-password/m-p/66090#M18695</guid>
      <dc:creator>tousifmehaboob</dc:creator>
      <dc:date>2019-01-08T17:34:00Z</dc:date>
    </item>
    <item>
      <title>Check this. https:/…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Save-workbook-as-with-password/m-p/66091#M18696</link>
      <description>Check this.&amp;nbsp;https://exceloffthegrid.com/vba-code-password-protect-excel-file/</description>
      <pubDate>Tue, 08 Jan 2019 22:59:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Save-workbook-as-with-password/m-p/66091#M18696</guid>
      <dc:creator>AmiBarrett</dc:creator>
      <dc:date>2019-01-08T22:59:00Z</dc:date>
    </item>
    <item>
      <title>RE: Check this. https:/…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Save-workbook-as-with-password/m-p/66092#M18697</link>
      <description>I was trying to save the password protected excel, without any password (unprotect it. I have the password). I'm guessing there's no VBO for it.&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;BR /&gt;Venkata Pranav Reddy Thathireddygari&lt;BR /&gt;Engineer&lt;BR /&gt;HedgeServ&lt;BR /&gt;America/New_York&lt;BR /&gt;------------------------------&lt;BR /&gt;</description>
      <pubDate>Tue, 11 Jun 2019 15:11:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Save-workbook-as-with-password/m-p/66092#M18697</guid>
      <dc:creator>pranavred</dc:creator>
      <dc:date>2019-06-11T15:11:00Z</dc:date>
    </item>
    <item>
      <title>RE: Save workbook as with password</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Save-workbook-as-with-password/m-p/66093#M18698</link>
      <description>The MS Excel VBO has an action for this, it's called "Protect Workbook". You can pass the password and the workbook that you want to protect. ​However, if you want more functionalities, like specifying what you want to lock (like formatting, column width....) you will have to create your own action.&lt;BR /&gt;&lt;BR /&gt;If you are asking, how to unprotect a file and then save it without a password, Blue Prism doesn't have an out of the box object for that. You can achieve it either creating an object that interacts with Excel UI (not recommended considering that the UI might change with new versions of Excel) or you can create your own code.&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;BR /&gt;Melissa G.&lt;BR /&gt;America/New_York&lt;BR /&gt;------------------------------&lt;BR /&gt;</description>
      <pubDate>Wed, 12 Jun 2019 20:50:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Save-workbook-as-with-password/m-p/66093#M18698</guid>
      <dc:creator>MelissaSuarez_G</dc:creator>
      <dc:date>2019-06-12T20:50:00Z</dc:date>
    </item>
  </channel>
</rss>

