VBA and VB6 developer's tips

For Vba developers using Excel, Word, AutoCAD...


Remove VBA project password



This is a useful tip to take into account. For example, an old Excel VBA project happens to have launched an unexpected error, and the project file was password protected when it was installed ages ago. Your customer doesn’t know the password. Perhaps the developer left the company and he was the only one who knew it. Of course that’s not an ideal situation, but you know these things do happen. So, what are we going to do now?. There is a ‘trick’, or a workaround –if you prefer- to deal with this issue. Here’s the tip. You will need to get an Hexadecimal editor. Some freeware ones are easy to find. This example will be using the HxD editor.

Just open the VBA project file with HxD. Find the string “DPB”.

Change it to “DPx” and Save the project file.

Open the project file with Excel.

Excel will show warnings, but just click OK until it’s open.

Now press ALT + F11, and go change the project’s password without removing it.

Note the new password.

Save, Close and Open back.

Press ALT + F11 again and go enter the new password.

Now you can go to the project Properties and remove the password.

Save.

You’re done.



            Source      http://vbaforum.blogspot.com

Reviews:

Post a Comment

Asian Tour Trip © 2014 - Designed by Templateism, Distributed By Blogger Templates | Templatelib

Contact us

Powered by Blogger.