![]() ![]() Vba Project Password Excel![]() Option Explicit Sub X() MsgBox 'hello, world!' End Sub----- 3) Saved the workbook as Libro1.xlsm. Advantages disadvantages open source software. 4) Set VBA project password to 1234 and saved the workbook as Libro2.xlsm. 5) Copy both files from *.xlsm to *.zip. 6) Extracted both.zip files into folders Libro1 & Libro2 which each has this internal file structure: Protected VBA Project 01.png 7) Run WinDiff on both folders and got two differences: Protected VBA Project 02.png 1st (.docpropscore.xml) just because of the saved date time stamp, and 2nd (.xlvbaproject.bin) as the password protection difference. 8) Double clicked on 2nd difference and got this: Protected VBA Project 03.png where you have uncolored the lines that are equal, yellowed those of file 1 (unprotected) and reddish those of file 2 (protected). And greened into the ellipse the VBA code, in this case common to both of them. 9) Opened again Libro2.xlsm with Excel and saved it as Libro0.xlsx without macros. Empire earth iso. 10) Copied Libro0.xlsx as Libro0.zip 11) Unzipped Libro0.zip to folder Libro0 12) Checked that the only 'file' difference was the absence of vbaProject.bin. 13) Copied Libro2 folder as Libro3. 14) Deleted vbaProject.bin from folder Libro3xl.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |