oExcel = new Microsoft.Office.Interop.Excel.ApplicationClass();
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
So far, I get the following behaviour: The excel file is opened successfully, the macro is launched, but I get automation errors on basic VBA objects like "Application" or "ThisWorkbook" (see error window in attachment).
However, when I launch the macro from the excel file manually, it works!
Moreover, I have a similar program launching a macro in another excel file and it works.
Is it possible that my excel file is corrupted?
I found out that the max number of arguments when invoking the runmacro method is 10. If you try put more than 10 args, you'll get the same error as mine.
* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.