Help - VBA Password Lost

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have forgotten the VBA password that I had set for my Excel file. Now I
need to do some urgent code changes and Im unable to do so. I tried many free
VBA password recovery softwares but no luck as the demo versions have their
restrictions. Is there any other way possible without having to shell out
some bucks?

Thanks!
- Joseph
 
Hello Gord,

Thank you very much, but I kind of need this very urgently (pressing project
deadlines). Is there any other alternative?

- Joseph
 
Alternative to John's site?

I know of none and you say you have tried the free crackers so I'm out of ideas.

Now, if I had just paid more attention when browsing through John's site<g>


Gord
 
Hi Gord,

Thanks again ! I did do a search to find hex editors and got hold of xvi32.
I also found in another post
(http://groups.google.co.uk/group/mi...7c540?lnk=st&q=&rnum=1&hl=en#36662e9a3607c540)
describing how to open the VBA file with the help of a hex editor. Now Im all
at sea again as Im getting an error message that the file is corrupt. Luckily
I was testing this on a backup file and was able to retrieve the original
file.

Since Ive run out of ideas, I'll have to rewrite the whole program once
again. Whew! its gonna be a long day at work ....

- Joseph
 
All,

I tried to use hexeditor to change the VBA password, and I failed in first few attempts but was successful in the last attempt. I was making mistakes while copying the CMG,DPB and GC keys from new file to old file. Here are the excat steps that I did:

1) Created a new file A1234.xls and set the VBA password to A1234.
2) opened A1234 and the file that I wanted to recover from Hexeditor
3) copied all the keys in one shot

E.g.

CMG="D1D37D7B817B817F857F85"
DPB="A2A00E9DC2BAC2BA3D46C3BADD69D27B23478A2D585E860B536A4F566325A1B601B5010A7C"
GC="7371DFCCB1CDB1CD4E"

or

43 4d 47 3d 22 44 31 44 33 37 44 37 42 38 31 37
42 38 31 37 46 38 35 37 46 38 35 22 0d 0a 44 50
42 3d 22 41 32 41 30 30 45 39 44 43 32 42 41 43
32 42 41 33 44 34 36 43 33 42 41 44 44 36 39 44
32 37 42 32 33 34 37 38 41 32 44 35 38 35 45 38
36 30 42 35 33 36 41 34 46 35 36 36 33 32 35 41
31 42 36 30 31 42 35 30 31 30 41 37 43 22 0d 0a
47 43 3d 22 37 33 37 31 44 46 43 43 42 31 43 44
42 31 43 44 34 45 22


4) Found the exact location of CMG key in the new file and pasted the above
5) There were some extra characters left in my old file for the key GC - this happened due to difference in size between the keys of the old file and the keys from the new file.
6) I did not delete the extra characters.
7) Saved the old file and opened it from excel and the password was changed to A1234.

Hope this helps.
 
Back
Top