Results 1 to 7 of 7

Thread: Advice on password for code

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2004
    Location
    in the heart of the Mediterranean
    Posts
    1,143

    Advice on password for code

    hi,

    I have a excel file which has VBA code which has a password. A colleague left and the password has gone with him as well. Is there a way to bypass this password so that I can edit a dropdown list.

    Thanks

  2. #2
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Advice on password for code

    Yes, do a google search for "VBA Password Recovery" and you will get a bunch of hits for legitimate programs that use alogorithums and brute force attacks to figure out the password.

    There is no way to gain any type of programmatic access to any underlying function, property, or method that will unprotect it.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2004
    Location
    in the heart of the Mediterranean
    Posts
    1,143

    Re: Advice on password for code

    hi RobDogg88,


    Thanks as always for your prompt help. I will do the search and hope I can come around with something.

    I have not understood the last sentence, could be my English. can u please specifiy what I cant do just in case I get to surpass the password?? Thanks

    [QUOTE]There is no way to gain any type of programmatic access to any underlying function, property, or method that will unprotect it.[/QUOTE

  4. #4
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Advice on password for code

    Oh, I was just stating that your better off using a utility type of program to do a brute force attack on it since there is no way to program a recovery for the password.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  5. #5
    New Member cavemanpz's Avatar
    Join Date
    Nov 2005
    Posts
    12

    Re: Advice on password for code

    Search for "Advanced Office Password Recovery Professional Edition"

    Types of attack:

    - Brute-Force attack (trying all possible combinations),
    - Brute-Force with Mask (If some Password symbols are known),
    - Dictionary attack.

    Professional Edition of AOPR has a "VBA Backdoor". Feature that allows to bypass VBA Password checking in any Application.

  6. #6

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2004
    Location
    in the heart of the Mediterranean
    Posts
    1,143

    Re: Advice on password for code

    hi ,

    Is there a trial version online that works?? I just need it for a single Excel file to open its VBA code.


    Types of attack:

    - Brute-Force attack (trying all possible combinations),
    - Brute-Force with Mask (If some Password symbols are known),
    - Dictionary attack
    What are these above, are they features in the Advanced Office Password Recovery Professional Edition.
    I have found the trial version but does not do anything. Am I doing something wrong. I have never done any type of cracking before so please give me some hints please.

  7. #7
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Advice on password for code

    There should be not much to it. Just run it on the desired file. Perhaps there is more documentation on the password recovery site.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

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



Click Here to Expand Forum to Full Width