转自:http://club.excelhome.net/thread-868920-1-1.html
Excel vba如果报错,直接导致代码卡死,无法继续。可以禁用vba,亲测以下方式对workbook_open之类的vba事件也有效,设置一下程序属性就完了:
Excel.ApplicationClass excelApplication = new Excel.ApplicationClass();
excelApplication.Visible = false;
excelApplication.AutomationSecurity = MsoAutomationSecurity.msoAutomationSecurityForceDisable;
另外针对其他的excel弹框卡住代码,还可以设置无弹出任何警告框:
excelApplication.DisplayAlerts = false;