From: Chris on 20 Jan 2010 05:35 I have a question on an old method on unlocking access to VBA Modules. I am following the process as follows: 1. Create a new simple excel file. 2. In the VBA part, set a simple password (say - 1234). 3. Save the file and exit. 4. Open the file you just created with a hex editor. 5. Copy the lines starting with the following keys: CMG=.... DPB=... GC=... 6. FIRST BACKUP the excel file you don't know the VBA password for, then open it with your hex editor, and paste the above copied lines from the dummy file. 7. save the excel file and exit. 8. Now, open the excel file you need to see the VBA code in. The password for the VBA code will simply be 1234 The issue is as follows: the unknown password file CMG, DPB and GC string has a length of 134 bytes; however, the files that are created have a lengths (varies alternatively between 139 and 141. Is there any advice to help me recover this lost file?
From: Simon Lloyd on 20 Jan 2010 07:06 Sorry, but although Excel's protection is very weak i don't think you will find people very willing to help circumvent it. There are retail programs out there that can do this for you! Chris;617777 Wrote: > I have a question on an old method on unlocking access to VBA Modules. > > I am following the process as follows: > 1. Create a new simple excel file. > 2. In the VBA part, set a simple password (say - 1234). > 3. Save the file and exit. > 4. Open the file you just created with a hex editor. > 5. Copy the lines starting with the following keys: > CMG=.... > DPB=... > GC=... > 6. FIRST BACKUP the excel file you don't know the VBA password for, > then open it with your hex editor, and paste the above copied lines > from the dummy file. > 7. save the excel file and exit. > 8. Now, open the excel file you need to see the VBA code in. The > password for the VBA code will simply be 1234 > > > The issue is as follows: > the unknown password file CMG, DPB and GC string has a length of 134 > bytes; however, the files that are created have a lengths (varies > alternatively between 139 and 141. > Is there any advice to help me recover this lost file? -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=171653 [url="http://www.thecodecage.com"]Microsoft Office Help[/url]
From: Mike H on 20 Jan 2010 07:14 Chris, VB project passwords are a lot more robust then workbook/worksheet passwords. I use this for project passwwords http://www.lostpassword.com/excel.htm?refid=990017&utm_source=google&utm_medium=ppc&utm_content=ad_03&utm_campaign=adwords_excel -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Chris" wrote: > I have a question on an old method on unlocking access to VBA Modules. > > I am following the process as follows: > 1. Create a new simple excel file. > 2. In the VBA part, set a simple password (say - 1234). > 3. Save the file and exit. > 4. Open the file you just created with a hex editor. > 5. Copy the lines starting with the following keys: > CMG=.... > DPB=... > GC=... > 6. FIRST BACKUP the excel file you don't know the VBA password for, > then open it with your hex editor, and paste the above copied lines > from the dummy file. > 7. save the excel file and exit. > 8. Now, open the excel file you need to see the VBA code in. The > password for the VBA code will simply be 1234 > > > The issue is as follows: > the unknown password file CMG, DPB and GC string has a length of 134 > bytes; however, the files that are created have a lengths (varies > alternatively between 139 and 141. > Is there any advice to help me recover this lost file? > . >
|
Pages: 1 Prev: Restricting activation of a form button Next: Conversion from 123 to Excel |