Articles for the Month of July 2014

Avoiding MSDN’s Download Manager… Because it’s horrible!

Have you ever tried downloading anything from Microsoft using Microsoft’s Download Manager? If you have, then you know what I’m talking about when I say that IMHO that software is absolutely a piece of garbage. And whoever decided to make it that way needs to be fired from Microsoft (mabe not fired, but definitly demoted for the aweful job he/she has done on this thing). I mean it’s called Download Manager, but the only thing it can’t do is download one piece of software without some sort of error!!! Actually Richard Banks has a funny article about his encounters with this Download Manager (granted his article is from 2007, but I don’t think Microsoft has changed their software much)!

But since you are here, probably you want to know how to avoid using MSDN’s Download Manager. Well, there is a great extension for FireFox, which is called DownThemAll!, which can be your best friend here. Just add it to your FireFox and you’ll know what I mean.

dl-down0

After adding it to your FireFox browser, navigate to where you want to download the file from and choose “Web Browser” instead of “Download Manager” from the Download Method drop down box, and click continue.

dl-webbrowser

When FireFox’s download window opens up, choose DownThemAll, and hit OK

dl-down5dl-down3

Choose where you want the file to be saved and hit Start!, and Voila!!! You even get full speed download rather than 1MB/s limit from Download Manager!!

dl_max1

Also, if the download gets stuck, just right-click and pause the download, then right click and click resume. This will resume the download and it wont fail :D. Yay!!!!!

dl-pause1

dl-resume1I

I hope this saves somebody some time 🙂

Cracking Excel’s Password

Wow! It’s been so long since I’ve written anything here. 1 year and 4 days to be exact! You know, I wanted this blog to be link my code repository as well… but as the tasks become more complex, writing about them and explaining how they have been solved are getting harder and harder.

But this one I had to save here, since it took me couple of hours to find. I have to emphasize that I didn’t write any of the code myself so here is the original post... You know, credit where it’s due!

So, Here is the problem I had this morning: An old MS Excel spreadsheet that with a protected workbook and I had forgotten the password. I’m sure you have been in that situation before. So I started searching for ways to crack it and I found a bunch of applications (Free!!!) that does it for you. But since I don’t want to just install any application I find off the web on my personal PC, I kept looking and found the following VB script that works like a charm. Here is how to use it:

Open the workbook that has the protected sheet in it. Hit Alt+F11 to view the Visual Basic Editor. Hit Insert-Module and paste this code into the right-hand code window:

Sub PasswordBreaker()

'Author unknown but submitted by brettdj of www.experts-exchange.com

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)
ActiveWorkbook.Sheets(1).Select
Range("a1").FormulaR1C1 = 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

Close the VB Editor window. Navigate to the worksheet you want to unprotect. Hit Tools-Macro-Macros and double-click PasswordBreaker in the list