C# Interop Excel Macro With Password - Is It Possible?

Question

Does anyone know if it is possible to run a macro embedded inside a workbook which has a password enabled?

Basically I am able to run a macro in a workbook already - However in my manager wants a freaking password added and I don't think thats possible

Has anyone managed to get this in place?

Where do you want the password added? Upon running of the macro? Or does the workbook have a password? — McKay
– McKay, Commented Nov 24, 2009 at 17:06
Yes, I realize the workbook has a macro, but where should/does the password live? — McKay
– McKay, Commented Nov 24, 2009 at 17:58

mattdlong · Accepted Answer · 2009-11-24 17:51:01Z

1

Are you trying to open the workbook in code and then run the macro?

The open method on the workbook object accepts a password as a parameter.

answered Nov 24, 2009 at 17:51

mattdlong

8762 gold badges7 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Oorang · Accepted Answer · 2009-11-25 04:43:39Z

0

As mentioned, the Open method can be passed a password. However it's worth noting that hard-coded passwords are pretty trivial to extract from an exe. IMHO it's better to just catch the exception to the open method, prompt the user for the password, and then retry the open method with the provided password.

answered Nov 25, 2009 at 4:43

Oorang

6,7901 gold badge38 silver badges54 bronze badges

Collectives™ on Stack Overflow

C# Interop Excel Macro With Password - Is It Possible?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related