I've been asked to convert an excel workbook to web format. The original has lots of macros and VB script in it. Unfortunately the guy who built it put password protection on it so not only can I not see the code behind it I cant save it into any other format either. He's is now departed and no-one else here knows the password. Any suggestions on getting around this other than documenting all the functionality and starting from scratch?
-
-
Just type "vba password recovery" into google, and should get some options for utilities that crack the password for you. -
Originally posted by BradNeedsYourHelp
Tried a couple of the freeware pasword recovery / cracking tools found via google and got no joy. I was hoping someone would have some recommendations.Comment
-
Get it to crash. This normally defaults it into the VBA Editor.
Ie. Remove something its looking for and run it.What happens in General, stays in General.You know what they say about assumptions!Comment
-
Oi! Theres loads on the web you lazy git.
Do you want us to come round and convert it for you as well!!!
Bloody lazy contractors!What happens in General, stays in General.You know what they say about assumptions!Comment
-
It's not laziness it's cost effective outsourcing
Comment
-
..
Look for "passware" - excellent tool. Costs though, unless you're into 'stealing' cracks.
Comment
-
Sorted it, found a freebie one that did the job.
It's actually an excel plug-in that removes the password altogether rather than trying to decipher it.
Can be found here if anyone else needs similar.Comment
-
Whoops! Maybe I 'd better take my bank details out of my passwords sheet!bloggoth
If everything isn't black and white, I say, 'Why the hell not?'
John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)Comment
-
This only removes the password protection on the sheets though, doesn't it? It doesn't remove the password protection to access the code.Comment
Comment