.net office automation project protected issue

Question

I'm opening up an excel file which is project protected ie. I can't add a vba module to it.

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

Answer 1

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