cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Protected Worksheet

MahmudBarrak
Level 2
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
3 REPLIES 3

NevilleWatson
Level 4
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.

MahmudBarrak
Level 2
Thanks a lot Neville. Could you please forward the xml to this adress: mahmoud.barrak@fr.ey.com ? Thank you!

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