JoelDixon.com

"And so I ask you this one question. Have you ever tried simply turning off the TV, sitting down with your children, and hitting them?" - Bender, Futurama 4ACV06

Blog
General
Travel
Hockey
Technical
Gaming
Catalogue
Movies
TV Shows
Music
Video Games
Stats
Pages
Travel Plans
Live Music
Phone History
Things to Do
Europe Trip - 2012
Links
About


Blog Archive
Current Blogs
June 2011 (1)
January 2011 (1)
2010 (18)
2009 (28)
2008 (25)
2007 (67)
2006 (23)
2005 (32)
2004 (10)

Blog Tags
General
10 in '10 (4)
Books (1)
DVDs (3)
Funny (13)
Gadgets (5)
Hawt (1)
Movies (14)
Music (7)
Pets (4)
Recipe (16)
Running (3)
TV Shows (2)
Web (29)
Travel
Calgary (2)
Edmonton (12)
Kuala Lumpur (1)
New York (7)
Niagara Falls (2)
Phuket (2)
Pittsburgh (5)
Washington (4)
Hockey
Pittsburgh Penguins (25)
Technical
.NET (3)
Java (4)
Software (3)
Work (2)
Gaming
Commodore 64 (2)
Master System (1)
Mega Drive (1)
Rock Band (1)
Xbox 360 (16)
XNA (1)

The rarely updated blog of Joel Dixon
< Checkers | Travel Plans >

Wednesday, July 13, 2005

Remember Me! <flaming eyeballs>

# Posted by Joel Dixon at 13/07/2005 11:58:00

Well, my USB key wiped itself again (third time thus far) which is very annoying. I use it to store old work, and common code I'm always looking up. An example of this is VBA code required to unlock a protected Excel workbook (for whenever I want the answers to the latest Excel Quiz doing the rounds):

VBA Code:

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

I've decided to start posting things like that here - and use my USB key for transport rather than storage.


Back to Top

Comments

No comments have been made.

You must be logged in to comment
Blog Search

Advanced Search


Recent Blogs
Log o' cats
I'm number 1!
Resolute
Phuket, Thailand - 2010
Mr. Potato Head Mashups
Random Travel #2 - Thailand
You have been the ones, you have been the ones for me.
Balls
Caramelised Pumpkin Risotto
Malaysian Vegetable Curry

Feed
Subscribe to feed Blog Entries

Add to Google
Add to My Yahoo!

Recent Comments
Log o' cats
posted 10 months ago by joeldixon
ha ha - I didn't mention that I bought two copies of Lock, Stock after the creation of this catalogue ... link

Log o' cats
posted 10 months ago by Brad
I made a DVD list for the same reason and just last week bought The Green Mile on Blu-ray before ... link

Balls
posted 2 years ago by joeldixon
Exactly. What's wrong with the kids today when they can't spell genitals? And you and I have been using ... link

Balls
posted 2 years ago by abrereton
I'm just glad that they spelt it correctly in the end. link

Kuala Lumpur, Malaysia - 2010
posted 2 years ago by joeldixon
Definitely, you have to let us know when you're free for UBs! link


Comment Standings
1. the man with no name (45)
2. Hoff (39)
3. Gav (27)
4. Hitman (26)
5. Brad (23)
6. Eryc-Ads (13)
7. Deep Lurker (6)
8. thefury (5)
9. Dieter (4)
10. Zelks (4)
About This Site | Contact Me | 73 days until I leave for Portugal