Jenny Spencer

Graeme,

I know you will probably never even know this is here, but at least if I post this is my way of remembering for you.

Rest in peace Jenny.

Michael

Excel Password Unlocking Code

Apparently works up to Excel 2011.  Which is good, as I’m in no rush to go to the subscription only model of 2013 onwards.

 

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

American Driver in France

Loved France and Spain.   Lots of memories from this.

 

The one that might stick the most however was seeing an American (as in US of A) who tried to drive up a pathway that was clearly marked as pedestrian only.

Admittedly, the sign was in French.

By the time we got there he had managed (somehow) to turn his car around to drive back down before getting stuck.  I have no idea how he could have turned his car around, but suffice to say that he had been there for an hour by the time we showed up.

If a picture is worth a thousand words, then a video must be worth a million. Possibly two million – one for each video.

Enjoy.  I’d suggest you take advantage of the fullscreen icon to really get the full benefit.

Michael

Energy, Tech and Dogs