Open password protected Excel-worksheet - lost password

Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
For details you can visit our website:
http://www.familycomputerclub.comYou can use Google Docs through your Gmail account to open a password protected Excel worksheet whose password you have lost. The process involves the following steps:
1. Create a Gmail account
2. Log into your Gmail account
3. Click on documents
4. Click on upload
5. Google Docs automatically allows you to make changes and saves the file
6. Download the file as an 'Excel' file
7. It is saved as an 'xls' file which means the version 1997 to 2003.
8. We can now 're-save' the file using our Excel 2007 application in the 'xlsx' format
http://www.youtube.com/watch?v=aJw9_p...
Attention: Google Docs no longer allows the import or opening of MS-Excel password protected files anymore!
Here's another useful link for password recovery: http://www.freeoffice.vbapasswordreco...
If things fail then also try this VBA procedure:
Sub PasswordBreaker() 'Author unknown '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
More details can be found here:
http://spreadsheetpage.com/downloads/...
http://spreadsheetpage.com/index.php/...