Help - VBA Password Lost

[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

 

[Gord Dibben]

You can do this with a simple hex editor which can be found on the 'net free.

See what JE McGimpsey has for you at

http://www.mcgimpsey.com/excel/fileandvbapwords.html

I just checked the URL and John's site is temporarily down at present.


Gord Dibben MS Excel MVP

 

[Guest]

Hello Gord,

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

- Joseph

 

[Bernard Liengme]

Need help with VBA? See David McRitchie's site on "getting started" with VBA

http://www.mvps.org/dmcritchie/excel/getstarted.htm
best wishes

 

[Gord Dibben]

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

 

[Guest]

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

 

[Stan Brown]

Sat, 14 Jul 2007 09:52:53 -0700 from <Gord Dibben

Alternative to John's site?

www.archive.org probably has an archived copy, but I haven't checked.

 

[shivali.mittal]

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.