JoelDixon.com

"Bite my shiny metal ass!" - Bender, Futurama 1ACV01

Blog
General
Travel
Hockey
Technical
Gaming
Links
About


Blog Archive
Current Blogs
November 2008 (1)
October 2008 (3)
September 2008 (1)
August 2008 (4)
July 2008 (3)
June 2008 (1)
May 2008 (1)
April 2008 (3)
March 2008 (3)
February 2008 (3)
January 2008 (1)
2007 (67)
2006 (23)
2005 (32)
2004 (10)

Blog Tags
General
DVDs (2)
Funny (6)
Gadgets (5)
Hawt (1)
Movies (10)
Music (5)
Pets (3)
Recipe (14)
TV Shows (1)
Web (20)
Travel
Calgary (2)
Edmonton (12)
New York (7)
Niagara Falls (2)
Pittsburgh (5)
Washington (4)
Hockey
Pittsburgh Penguins (17)
Technical
.NET (2)
Java (4)
Software (3)
Work (2)
Gaming
Commodore 64 (1)
Master System (1)
Xbox 360 (13)

GamerTag


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.

Add Comment

(not required) (not required) (not required) Will be disguised on the site (not required) HTML Code is allowed | BBCode is allowed | Image links are allowed
Blog Search

Advanced Search


Recent Blogs
Street Fighter: The Later Years
Stop looking at me, swan!
Trivial
Awesome Blossom!
Not Will Ferrell Trivia
Timmy didn't think about the Mini-Feed
Thongs and Superglue
The Deep Voiced Knight
Jonathan Roy charged with assault
Superman x 4

Feed
Subscribe to feed Blog Entries

Add to Google
Add to My Yahoo!
Add to Netvibes

Recent Comments
What a waste
posted 4 months ago by joeldixon
I'm not 100% sure - I may have still been using Windows 98 back then (very old computer). I'm ... link

What a waste
posted 4 months ago by Tomek
U haven't said what win version u use, but my pentium3 with XP SP2 installed worked just fine after about ... link

The Deep Voiced Knight
posted 4 months ago by joeldixon
You're right - Christian Bale is a good Bruce Wayne - and if he toned down the scary voice he'd ... link

The Deep Voiced Knight
posted 4 months ago by thefurey
haha - why did delta cut her hair? i actually dont mind bale as batman...well, actually, he's a very ... link

The Deep Voiced Knight
posted 4 months ago by joeldixon
Yeah - for most of the movie I forgot that it was him. Then again, I didn't even notice ... link


Comment Standings
1. the man with no name (45)
2. Hoff (39)
3. Gav (27)
4. Brad (20)
5. Hitman (16)
6. Eryc-Ads (13)
7. Deep Lurker (6)
8. Dieter (4)
9. thefurey (4)
10. Zelks (4)

About This Site | Contact Me