CODEWITHSUNDEEP
c#vba
Jack Kada
Jack Kada

Reputation: 25262

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

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?

Upvotes: 0

Views: 499

Answers (2)

Oorang
Oorang

Reputation: 6780

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.

Upvotes: 0

mattdlong
mattdlong

Reputation: 876

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.

Upvotes: 1

Related Questions