Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: passwords

  1. #1
    Board Regular
    Join Date
    May 2002
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Recently, some kind person on this site, gave the vba code for opening worksheets having forgotten the password. Is there a code for workbooks. I saved a lot of workbooks when first I started experimenting with vba but I have forgotten the Passwords.

    Greatful as always for any help.

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nope. VBA isn't going to do it. You're going to have to use a password cracker type thingy. There's a couple recommended on this site at:

    http://www.mrexcel.com/#pwd

    Additionally, I'd use the "search" link on this site because I recall someone posting some more useful information about possbily free password cracking services.


  3. #3
    Board Regular
    Join Date
    May 2002
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Mark. You never cease to amaze me with your wealth of knowledge.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Go to http://www.straxx.com and download the password remover add-in. This one works great. All he requests is a postcard from you.


    I appreciate the help from everyone at Mr. Excel.

    viper

  5. #5
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    One site I like for this type of software is "crak".
    http://www.crak.com/downsoft.htm
    <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

  6. #6
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well actually you can do it via VBA
    You just need a VAST amount of time and a
    Large Dictionary, using a Brute force method.


    Kind Regards,
    Ivan F Moala From the City of Sails

  7. #7
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-13 15:16, Ivan F Moala wrote:
    Well actually you can do it via VBA
    You just need a VAST amount of time and a
    Large Dictionary, using a Brute force method.
    Your code would be screwed by "kajsdfkljhaslkwio234@#$w434kh", then, huh? )

  8. #8
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-14 19:37, Mark O'Brien wrote:
    On 2002-05-13 15:16, Ivan F Moala wrote:
    Well actually you can do it via VBA
    You just need a VAST amount of time and a
    Large Dictionary, using a Brute force method.
    Your code would be screwed by "kajsdfkljhaslkwio234@#$w434kh", then, huh? )
    Yup..thats exactly right!

    Using Brute force No good, But typical users put in more meaninful passwords even though they may have been told Not to. Book protection is a little more complicated then Sheet code, the
    hash generation algorithm is the same as
    with sheet protection, but the whole
    document is encrypted. However the password
    that is entered which is used to encrypt the
    document is a fixed key stored in the MS
    Excel program code ? Is it any wonder that
    there is an abundance of excel cracks avail.
    This key is generated from the Password "VelvetSweatshop".
    If you protect a MS Excel workbook with this
    password, no password is required to open
    the document!!!




    Kind Regards,
    Ivan F Moala From the City of Sails

  9. #9
    Board Regular
    Join Date
    Apr 2002
    Location
    Midlands, UK
    Posts
    217
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you can open it as read only this code will remove the pasword on the file :

    Sub workbook_breakIt()

    Dim i As Integer, j As Integer, k As Integer, l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer, 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
    Workbook.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
    Exit Sub
    End If
    Next n
    Next i6
    Next i5
    Next i4
    Next i3
    Next i2
    Next i1
    Next m
    Next l
    Next k
    Next j
    Next i
    End Sub

    Please don't ask how it works because I don't have a clue - someone sent it to me ages ago ( appologies if you're that someone - I've forgotten who you are ).

  10. #10
    Board Regular
    Join Date
    Apr 2002
    Location
    Midlands, UK
    Posts
    217
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    or you could try this site for some software

    http://www.passwordservice.com/_index.htm

    I think it costs about $25 or $30 for the software, and it's never let me down yet.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •