Hi,

 

I was in a similar situation a few months back and found this "brute force"
method... I simply added it to a module and ran it and it worked a treat,
only took a few seconds to get the password. Maybe it will work for you.

 

Sub PasswordBreaker()

 

  'Author unknown but submitted by brettdj of www.experts-exchange.com

  

  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)

   ActiveWorkbook.Sheets(1).Select

   Range("a1").FormulaR1C1 = 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

 

Regards,

Matt Turner

BuiltWith.Net <http://builtwith.net/> 

 

From: [email protected] [mailto:[email protected]] On Behalf Of Grant Molloy
Sent: Sunday, 28 June 2009 4:11 PM
To: [email protected]; [email protected];
[email protected]
Subject: OT - Office Password Remover / Revealer

 

Hi Lists..

 

I've been asked to continue developing an XL document that I was working on
a few years ago.

At the time it was quite hush hush, so I password protected access into the
file, and now  I cannot remember the password..

 

Ok.. I'll wait until the laughter subsides..... ... .... ... done?  good..

 

Just wondering whether anyone has a favourite or knows of a fantastic
product that will reveal or remove the password for me..

Free is great, paid services (which I've found plenty of) are ok too..

 

TIA.

 

Grant

-- 

Alfred Hitchcock
<http://www.brainyquote.com/quotes/authors/a/alfred_hitchcock.html>   -
"Television has brought back murder into the home - where it belongs." 

  _____  

Support procedure: https://www.codify.com/lists/support
List address:  <mailto:[email protected]> [email protected]
Subscribe:  <mailto:[email protected]> [email protected]
Unsubscribe:  <mailto:[email protected]>
[email protected]
List FAQ:  <http://www.codify.com/lists/oztfs>
http://www.codify.com/lists/oztfs
Other lists you might want to join:  <http://www.codify.com/lists>
http://www.codify.com/lists

--------------------------------------------------------------------------------
Support procedure: https://www.codify.com/lists/support
List address: [email protected]
Subscribe: [email protected]
Unsubscribe: [email protected]
List FAQ: http://www.codify.com/lists/oztfs
Other lists you might want to join: http://www.codify.com/lists

Reply via email to