Nilesh’s Weblog

August 29, 2008

Excel WorkSheet Password

Filed under: Microsoft Excel — Tags: , , , , — deshnilesh @ 5:12 pm

I again forgot my password for a excel worksheet and then begin mission to crack it :). Fortunately I cam across this code which will give you a alternate password. There is more detail discussion about how it works on the site, I am copying the code here for my reference so in future if I need it again I won’t have to search again.

Sub PasswordBreaker()
‘by Bob McCormick on NG: microsoft.public.excel.misc

‘on 22 May 2001.
‘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 126ActiveSheet.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

Advertisements

October 16, 2007

Add-In Passwords

Filed under: Microsoft Excel — Tags: , , , , , , , — deshnilesh @ 7:14 am

Ever tried to open TDExcelAddin.xla?

You won’t be able to open without this password ‘tdtdtd’

Try your hands on the VBA Code its interesting. Am looking for the API’s will share as soon as I get it.

Update :-

You will find one more XLA by default – funcres.xla
Try opening it with Password – Wildebeest!!

Blog at WordPress.com.