It can be opened and read using an OLE document container such as a DocFile viewer that is available in the tools menu of VB 6.0 or the OLE Viewer which is available as freeware on the internet. “VBAProject.bin” is a default name given by MS Office to the binary VB Project file. The VBAProject.bin is a binary file of any VBA project (as described above, an Excel workbook or document with a macro) that contains all the code modules of the project/workbook in it. Otherwise, you can just run, but not view, the modules. If you type the correct password, you will be given an access to the project code. Clicking on the create button will ask you for the password.If we want to create / edit, we can type a new procedure name in that edit box as below.But we see that all buttons except “Run” are disabled. On opening a workbook which contains a password protected VBA project, we may try to view or edit the code of any module.For this to work, the Excel workbook has to be closed and re-opened. Click on the ok button and close the dialog box. Enter a password and confirm the same in the second text box too. Select the “Lock project for viewing” option.Select the “Protection” tab in the “VBAProject – Project Properties” window.Right click on the VBA Project in the Project Explorer.This can be done through the following steps. Just like how Excel offers protection to its sheets / data using passwords, it is possible to protect a VBA project’s code too. Extraction of source code from the VBAProject.bin file:.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |