Help - VBA Password Lost

[Sanjeev Unnikrishnan]

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

 

[Joseph]

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

 

[Joseph]

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.