open the encrypted file via vba macro

**Sukpal** · 07-09-2013, 07:24 AM

Is it possible to open the encrypted file via vba macro? I encrypted the file with password :MY_PWD and I've to open same file. I tried with ActiveWorkbook.unprotect Password:="My_PWD" in workbook open() event. even if the macro is enabled it asks me to enter the password. can we bypass that problem? wont it take the password from the code or how can we give the password via VBA?

BR
P Sukumaran

**JosephP** · 07-09-2013, 07:38 AM

if you are opening the workbook in code you can supply the password argument to the Open method; you can't do anything with code in that same workbook