For the community, please note... the "zip method" works for password protected worksheets and structure (within the spreadsheet). If your Excel file is password protected from OPENING (this is a different set of security parameters); the zip method will not work. You will encounter errors from your zip application stating the file is invalid, etc.
Thank you for your share I try unzip (7-zip) error show below: "Warning Cannot open the file as [zip] archive The file is open as [Compound] archive" and only show 3 folder or files: [6]DataSpaces EncryptedPackage EncryptionInfo How can fix? Thanks.
Zip method won't work with .xls files. I tried before with xlsx and it works just fine. When i open the protected file i press Alt + F11 and it won't open VBA. Sigh.
Hi there, thank you for your question. If you encounter an error stating "the file is damaged" when trying to unzip a file with both WinZip and 7-Zip, it indicates there might be an issue with the file itself, or the download was not completed properly.
@@wondersharerepairit8587 sorry, nothing wrong with files, the point is ms solved that security problem, u can confirm it by saving a brand new file with a pw, and u ll see the "zip" method doesnt work anymore.
Hey, I'm not able to unlock my xls file... It gives an error of file corrupted which isn't true... Coz when i had given this to online decrypt website, they gave me the file look snapshot which is accurate... This itself means the file isn't a corrupt one... Kindly suggest
Tried the zip file method first - no luck. Get messages that say "zip folder can't be opened because it's empty", or "zip folder is corrupted". Tried VBA editor next; finally figured out how to open the VBA editor, but where did you get the "provided code" that you copied and pasted into the module? Finally, tried the same online site that you used in the video. What you didn't make clear is that only weak passwords are free; strong passwords and brute-force are not (and this file is not worth the cost). At a loss as to what to do next.
Do a search on Google for the title of the macro and you’ll find the code. The guy who posted it years ago doesn’t even know where it’s from so unfortunately there is no credit to be given to the original person who came up with it.
Hi there, thank you for your question. It sounds like you've encountered a range of challenges while trying to remove a password from a Word document. The methods you've tried, including manipulating the ZIP file structure and using a VBA script, can sometimes work but are not foolproof and can encounter the specific issues you've described. Additionally, the limitations of free online tools, especially regarding stronger passwords, indeed make them less useful for more securely protected documents.
would be great to post that code... also do some post production check you show opening workbook and then edit the sheet protection that's not what 90% of people are out after. the code: Sub PasswordBreaker() 'Breaks worksheet password protection. Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _ Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) If ActiveSheet.ProtectContents = False Then MsgBox "One usable password is " & Chr(i) & Chr(j) & _ Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _ Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub or google sub passwordbreaker() 'breaks worksheet password protection
Is it that Microsoft has patched this zip type method? Cause it says invalid or corrupted zip can't open.
For the community, please note... the "zip method" works for password protected worksheets and structure (within the spreadsheet). If your Excel file is password protected from OPENING (this is a different set of security parameters); the zip method will not work. You will encounter errors from your zip application stating the file is invalid, etc.
any ideas/links that work?
@patf.1961 Unfortunately, not for the password protection for opening.
sit down and relax, yeah! I did. Thanks for the help!
This is just what I needed...thanks man!
You are just the lord of the rings man !!!
A crack !!!! Thank you so much and now on I am a new subscriber!!!
Huge like !!!
OH REALLY THANK YOU !I LOVE IT
thank you for this tutorial
If you cannot open the Excel file because it is password protected, you cannot insert a VBA module in that file. Very poor advice.
exactly
He explained it wrongly. That proceder removes sheet pw, not file pw.
Thank you for your share
I try unzip (7-zip) error show below:
"Warning
Cannot open the file as [zip] archive
The file is open as [Compound] archive"
and only show 3 folder or files:
[6]DataSpaces
EncryptedPackage
EncryptionInfo
How can fix? Thanks.
Hi Sir, Did you find a solution for your case? I have a similar one
cela donne avec succes bravo tu est un genie
sucess my friend. I love your video
Zip method won't work with .xls files. I tried before with xlsx and it works just fine. When i open the protected file i press Alt + F11 and it won't open VBA. Sigh.
Is lostmypass safe for personal data file ?
When I try to unzip error show " the file is damaged" what can I do. I used winzip and 7 zip both.
Hi there, thank you for your question. If you encounter an error stating "the file is damaged" when trying to unzip a file with both WinZip and 7-Zip, it indicates there might be an issue with the file itself, or the download was not completed properly.
My excel file is ok. but after converted the extension to .zip the error show.@@wondersharerepairit8587
@@wondersharerepairit8587 sorry, nothing wrong with files, the point is ms solved that security problem, u can confirm it by saving a brand new file with a pw, and u ll see the "zip" method doesnt work anymore.
Superb Sirji . Thanks a lot
It does not work with complicated pass word, with 10 digits.
thank you so much
Awesome!! Thank you!!
Hey, I'm not able to unlock my xls file... It gives an error of file corrupted which isn't true... Coz when i had given this to online decrypt website, they gave me the file look snapshot which is accurate... This itself means the file isn't a corrupt one... Kindly suggest
Thank you!!
how to get rid of password for an xlsm file, I forgot my password for it.
Tried the zip file method first - no luck. Get messages that say "zip folder can't be opened because it's empty", or "zip folder is corrupted". Tried VBA editor next; finally figured out how to open the VBA editor, but where did you get the "provided code" that you copied and pasted into the module? Finally, tried the same online site that you used in the video. What you didn't make clear is that only weak passwords are free; strong passwords and brute-force are not (and this file is not worth the cost). At a loss as to what to do next.
Do a search on Google for the title of the macro and you’ll find the code. The guy who posted it years ago doesn’t even know where it’s from so unfortunately there is no credit to be given to the original person who came up with it.
Hi there, thank you for your question. It sounds like you've encountered a range of challenges while trying to remove a password from a Word document. The methods you've tried, including manipulating the ZIP file structure and using a VBA script, can sometimes work but are not foolproof and can encounter the specific issues you've described. Additionally, the limitations of free online tools, especially regarding stronger passwords, indeed make them less useful for more securely protected documents.
am i supposed to type all that code in from a screenshot?
Hi there,
Could you please elaborate on your question? We're glad to help.
@@wondersharerepairit8587 Can you please provide in a text file the script to input into VBA?
password protected not working with zip system.. can't open file without password.
Apparently, that method only works with files from 2013 or earlier.
Hi there,
Could you please elaborate on your question? We're glad to help.
This doesn't work for Excel files that are encrypted with password.
salamat shopee
Hi there,
Could you please elaborate on your question? We're glad to help.
On this episode of how to get fired and prosecuted. Not good advice at all.
would be great to post that code...
also do some post production check you show opening workbook and then edit the sheet protection that's not what 90% of people are out after.
the code:
Sub PasswordBreaker()
'Breaks worksheet password protection.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
or google sub passwordbreaker() 'breaks worksheet password protection