I've accidentally and unintentionally put a password on a workbook which I can therefore no longer open. I have the previous version unlocked, however the latest version has updated macros. Is there any way to extract the macros from the protected workbook without knowing the password?
Asked
Active
Viewed 184 times
-1
-
Saving a workbook with a password does not prevent opening the workbook. You need to enter the password, then you can open the workbook. If it were simple to extract content from a password-protected workbook, what would be the point of using a password in the first place??!! Also, if I had a dollar for every question where people claim that they have forgotten the password, I'd be rich. On a forum like this, how would one know if somebody wants to access stuff they shouldn't or if they have genuinely forgotten a password to content they own? – teylyn Nov 03 '19 at 23:59
-
Confused by your comment "saving a workbook with a password does not prevent opening the workbook". Is that now that point of a password? – April Nov 04 '19 at 00:45
-
I'm just trying to save re-do ALL of Friday's work if possible. – April Nov 04 '19 at 00:45
-
Your question reads as if the act of putting a password on a workbook means that you cannot open it ("which I can therefore no longer open"). But a workbook protected with a password CAN be opened. You just have to supply the password. The reason you cannot open it is not that it's password protected. I have many workbooks that are password protected and I can open them all. The reason you can't open it is that you have not supplied the correct password. – teylyn Nov 04 '19 at 03:24
-
Make a copy of your book, rename the extension from "*.xlsm" to "*.zip", then if you unzip the zip file and you will find a /xl/vbaProject.bin within the ZIP archive. This is the binary file which contains the macros – David García Bodego Nov 04 '19 at 09:50
1 Answers
1
There is a minimum number of characters for an answer, but the short version is:
No.
teylyn
- 34,374
- 4
- 53
- 73