From: Chris on
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

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
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?
> .
>