Wednesday, 8 January 2014

VBA password remover

Hi,

I would like to present a simple macro (in a form of .xlsm workbook) which allows to 'remove' password protection from VB Project in '.xlsm' files. It was tested on the workbooks created in Excel 2007/2010. Macro works by the algorithm described in my previous post, so in fact it changes any password in VBA Project to 'macro'.

File stored here:
https://drive.google.com/file/d/0B6sFi5sSqEKbbTJBdC1LS0dYMUE/edit?usp=sharing

54 comments:

  1. Hi
    It dont work with .Xlsm files, I have checked it two files, error message when you Debug is: tmpWB=Nothing

    ReplyDelete
    Replies
    1. Hi,
      it does work with .xlsm files, it's only file format that this macro can work with. The error you get can be related to many thing - version of your Excel, environment on witch Excel is working (Windows, libraries, ..), specific the file that you're trying to unlock.

      But what exact error did you get (error number and description)?

      Delete
    2. It didn't worked for me too. Error message "File don't have VbaProject!". The file do have VBA code and ask for password which I forgot.

      Delete
    3. In such situation you can take the help of third party VBA Excel password remover tool which allows you to remove lost and forgotten password of Excel VBA file.
      Tool link: http://www.vbapasswordremover.org/

      Delete
  2. First I have to tell that my english is not perfect. But I want to tell that You save my life So Thank you so much friend. I prepared an excel utility 1 month ago and ı protect the vba.. Then As you know I forgot it. Today my boss told me That He wants to excel files in tomorrow morning. This was very important for me really you save my life. Thank you very very very much friend.

    ReplyDelete
    Replies
    1. Mine English either :). I'm glad that it helped you.

      Delete
  3. Hi Anton,
    I could successfully do it once. But every subsequent attempt on same file, i got error message "File don't have VbaProject!"
    pls help!!

    ReplyDelete
    Replies
    1. Hi,

      Try another version of tool 'Excel Unlocker.xlsm' (https://drive.google.com/file/d/0B6sFi5sSqEKbLUIwUTVhY3lWZE0/edit?usp=sharing) or send me your file I can have a look.

      Delete
  4. Wonderful, worked like a charm.
    Thanks!

    ReplyDelete
  5. Please send me ur id so that I can send u the file.

    My id is niladri.biswas2005@gmail.com

    ReplyDelete
  6. Anton, i'm facing a similar issue where the algorithm removes the vba password, however then opening the macro, it still prompts me for a password. Can you help? many thanks. cg

    ReplyDelete
    Replies
    1. I don't really understand your problem, this tool not removes the password from VBA Project but change it to 'macro', so unless you change settings in VBAProject Protection properties project will remain password protected.

      Delete
  7. Please send me ur id so that I can send u the file.

    My id is willywahyu46@gmail.com

    ReplyDelete
  8. Your program is wonderful.
    There is one kind of question.
    vba source file
    oApp.Namespace (CopyFname) .items.Item ("xl"). Getfolder.CopyHere FileNameFolder & "\ vbaProject.bin"
    What is the force must be modified to overwrite without overwriting the message?

    ReplyDelete
    Replies
    1. I'm sorry, but didn't understand your question; about what message you're asking?

      Delete
  9. Hi thank you for your sharing. Can you help me opening old excel "xls" with your program? Or how can I open "xls" files this program?

    ReplyDelete
    Replies
    1. Hi, no program doesn't work with .xls files. But you could try either convert your file to .xlsm or unlock file by manual method (http://lbeliarl.blogspot.hu/2012_12_01_archive.html).

      Delete
  10. I got this error message,
    Compile error:
    The code in this project must be update for use on 64-bit system. Please review and update Declare statements and then mark them with the PtrSafe attribute.

    How to fix it?

    ReplyDelete
  11. Thanks so much! I have been searching for a solution fruitlessly, until I came across your template. Works perfectly!

    ReplyDelete
  12. Thanks It's Perfect....

    Matur Nuwun ya......

    ReplyDelete
  13. It didn't work for me. I don't know where I am making mistake. It stops in middle and a zipped file is created. When I unzipped it, I got many folders and xml files. I don't know what to do with them?

    ReplyDelete
  14. Hi,
    while i run VBA_Unlocker , its ask to select file and i selected the required to file. After compiling a pop up comes as " password for vba_project='macro' ".
    After i entered the password it tells invalid password.
    Plz help....

    ReplyDelete
    Replies
    1. Actually for me also same issue but it will created another file with the macro password.. try to opn that

      Delete
  15. Superr... I often create XLSM files and had forgot the password.

    Thanks a ton for creating this

    ReplyDelete
  16. This is awsome. You deserve applauds..

    ReplyDelete
  17. Great job sir thanks a lot...

    ReplyDelete
  18. not working on 64bit system, please update?

    ReplyDelete
  19. You know your projects stand out of the herd. There is something special about them. It seems to me all of them are really brilliant!
    v-travelled |

    bestofgaytravel |

    numatravels |

    travelersrvreno |

    banshitravels |

    exploreuktravel |

    alsurtravel |

    dubaitravelshop |

    couchtravels |

    hwisetravel |

    ReplyDelete
  20. Hmm. Not bad, I have never heard about this band. Btw I was looking for homework help online . But I've found an odd information for my future project.
    hotel-travel-america |

    selecttoursinc |

    loire-forez-tourism |

    iranadventuretours |

    travelingarmenian |

    travel-prescott |

    travelswithmaddog |

    hometownnationalwa |

    costaricasolarhomes |

    greencostaricahomes |

    ReplyDelete
  21. I surprised with the analysis you made to make this particular publish incredible. Wonderful activity! 
    travelbusinessu |

    ribusiness4equality |

    marinebusiness |

    inthebusinessofhope |

    yallabusiness |

    businessforbreakfast |

    profitme |

    launchthebusiness |

    wildaboutcars |

    autocarsupdate |

    ReplyDelete
  22. Hi Anton,
    Seems it isnt working for me...
    Can I send you my file so you can check it?
    I would be really thankful

    ReplyDelete
  23. Forte schools offer a FREE trial musical classes Sydney for classes and some offer Learn Piano, Guitar, Singing, Saxophone, Flute, Violin, Drums and More a Free Trial private lesson.

    ReplyDelete
  24. This comment has been removed by the author.

    ReplyDelete
  25. This comment has been removed by the author.

    ReplyDelete
  26. Hi. Thanks for taking the time to make this into a routine. :-) I had been performing the procedure manually but had a number of xla files to do and so was looking for something to do them in batch mode. I modified your routine to do that. :-)

    Just a little issue I came across. I had some files that wouldn't load successfully as xlsm (excel wouldn't open them at all) but if they were renamed as xls then it would open them... it did however mean I needed to adjust the code in GeneralSub to ensure that the CopyFname ended in ".zip" and not just "zip"... without the ".zip" on the end the oApp.Namespace will fall over with a "Method Namespace of Object IShellDispatch5" failed error.

    So maybe you should consider making the small adjustment to your code to work on varying length file names (eg named as .xls or .xlsm). Also, to make it work on a group of files (as I did). Cheers, Warren.

    ReplyDelete
  27. Adzet is the world's leading Marketing Tools Platform - providing marketing strategy and business development strategy to small and medium businesses worldwide

    ReplyDelete
  28. Thanks for the useful information. I used for this purpose Manyprog Excel Password Recovery. It will help restore the password to Excel file, and can recover the password to Excel sheet. http://manyprog.com/excel-password-recovery.php

    ReplyDelete
  29. Nice blog, keep it up in this essays have a lot of information having mostly the students are generates the best essays skills.
    Vintage Rugs

    ReplyDelete
  30. It's a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a designer to create your theme? Fantastic work!
    microsoft excel vba training

    ReplyDelete
  31. This comment has been removed by the author.

    ReplyDelete
  32. With the help of Excel password cracker solution can unlock and crack Excel password with xls, xlsx, xltm, xla, xlm, xlam, xlsm and xlsb
    Read More: http://www.excelunlockertool.com/

    ReplyDelete
  33. With this superb solution of MS Excel password breaker you can break Excel password with all versions Excel file including xlsx, xls, xlsb, xla, xlam, xltm and xlsm

    read more

    http://www.excelpasswordrecoverysoftware.excelpasswordremover.com/

    ReplyDelete
  34. how to do for 2003 xls file password? when opened in Hex editor , didnt find DPB string

    ReplyDelete
  35. send to me phanhoangchinh27@gmail.com

    ReplyDelete
  36. i really like this article please keep it up.
    excel courses

    ReplyDelete
  37. Really appreciated you time and hardwork, very much grateful to you

    ReplyDelete
  38. Thank You Very Much for your hard work and sharing this, I was getting furious since a very long time.

    ReplyDelete
  39. I could not get any thing... And could not find your previous post which describe how to.. .. !!! ???

    Just frustrated

    ReplyDelete