<?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 Hi, in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Excel-Protected-Worksheet/m-p/55629#M9942</link>
    <description>Hi,
Could you also please forward the xml to this adress: scully2501@free.fr?
Because, I have a error ""The given key was not present in the dictionary""
Thank you</description>
    <pubDate>Tue, 26 Sep 2017 11:02:00 GMT</pubDate>
    <dc:creator>blancarddiane</dc:creator>
    <dc:date>2017-09-26T11:02:00Z</dc:date>
    <item>
      <title>Excel Protected Worksheet</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Excel-Protected-Worksheet/m-p/55626#M9939</link>
      <description>Hello, 

Can anyone please attach/upload to this post a modified Excel VBO to open an excel sheet with a password ? 

I tried to implement it in the Open Excel action but no success. 
Thank you</description>
      <pubDate>Fri, 25 Aug 2017 14:38:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Excel-Protected-Worksheet/m-p/55626#M9939</guid>
      <dc:creator>MahmudBarrak</dc:creator>
      <dc:date>2017-08-25T14:38:00Z</dc:date>
    </item>
    <item>
      <title>Hi,</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Excel-Protected-Worksheet/m-p/55627#M9940</link>
      <description>Hi,
The following code put into a new code object will unprotect a worksheet called ""File"".
Dim wb As Object
Dim ws as Object
Try
wb = GetWorkbook(Handle, Workbook)
ws = wb.Worksheets(""File"")
ws.Unprotect(Password)
Success = True
Catch e As Exception
	Success = False
	Message = e.Message
Finally
	wb = Nothing
End Try
I duplicated the ""Protect Worksheet"" object and modified the code stage with this code.  Replace the hard coded value ""File"" with the name of your worksheet.</description>
      <pubDate>Mon, 28 Aug 2017 15:01:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Excel-Protected-Worksheet/m-p/55627#M9940</guid>
      <dc:creator>NevilleWatson</dc:creator>
      <dc:date>2017-08-28T15:01:00Z</dc:date>
    </item>
    <item>
      <title>Thanks a lot Neville. Could</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Excel-Protected-Worksheet/m-p/55628#M9941</link>
      <description>Thanks a lot Neville. Could you please forward the xml to this adress: mahmoud.barrak@fr.ey.com ? 
Thank you!</description>
      <pubDate>Mon, 28 Aug 2017 18:18:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Excel-Protected-Worksheet/m-p/55628#M9941</guid>
      <dc:creator>MahmudBarrak</dc:creator>
      <dc:date>2017-08-28T18:18:00Z</dc:date>
    </item>
    <item>
      <title>Hi,</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Excel-Protected-Worksheet/m-p/55629#M9942</link>
      <description>Hi,
Could you also please forward the xml to this adress: scully2501@free.fr?
Because, I have a error ""The given key was not present in the dictionary""
Thank you</description>
      <pubDate>Tue, 26 Sep 2017 11:02:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Excel-Protected-Worksheet/m-p/55629#M9942</guid>
      <dc:creator>blancarddiane</dc:creator>
      <dc:date>2017-09-26T11:02:00Z</dc:date>
    </item>
  </channel>
</rss>

