.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?

score 0 · Answer 1 · edited May 23 '17 at 12:26

0

Answers here, which could be translated to .net:

Tim

edited May 23 '17 at 12:26

Community

answered Mar 31 '11 at 19:48

Tim Williams

I don't want to crack the password. May be add macro as addin? or copy the file to another file without protection? I would like to know about these options and how to implement/ – ns12345 Mar 31 '11 at 20:18
@WhoIs: Maybe I'm misunderstanding what you mean by "execute a VBA module on this file", so maybe you could expand on that? I took it to mean you wanted to inseret some code into the VB project, but maybe you meant something else ? – Tim Williams Mar 31 '11 at 23:35

score 0 · Accepted Answer · answered Apr 01 '11 at 13:39

0

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

answered Apr 01 '11 at 13:39

ns12345

2 Answers2