How to run Excel macros from VS?

Question

How to run Excel macros from VS2010 (C #)? I am using the Microsoft.Office.Interop.Excel namespace

Answer 1

Try this article:

http://support.microsoft.com/kb/306683

The relevant part to run the macro is (where oApp is the application instance in your code):

 private void RunMacro(object oApp, object[] oRunArgs) { oApp.GetType().InvokeMember("Run", System.Reflection.BindingFlags.Default | System.Reflection.BindingFlags.InvokeMethod, null, oApp, oRunArgs); } 

Answer 2

In addition to amarsuperstar's answer,

I would like to state that you must be a reliable source to call these macros. And the Excel file itself also needs to be trusted.