.net office automation project protected issue

I'm opening up an excel file which is project protected ie. I can't add a vba modul开发者_JAVA技巧e to it.

But I need to execute a vba module on this file. How can I do that?

---

Answers here, which could be translated to .net:

How do I remove the password from a VBA project?

Tim

---

Figured out, copy all sheets to a new instance of workbook and then apply macro on that.!