C#使用Microsoft.Office.Interop.Excel组件时判断Excel文件中是否包含VBA代码

Workbook workbook = null;//是否包含VBA代码bool hasVBA = false;//打开EXECLworkbook = xlApp.Workbooks.Open(excelFile, Missing.Value, false, Missing.Value, Missing.Value, Missing.Value,Missing.Value, Missing.Value, Missing.Value, Missing.Value, false, Missing.Value, Missing.Value,Missing.Value, Missing.Value);//判断文件中是否包含VBA代码if(int.Parse(xlApp.Version) >= 12) {//Excel2007(包含)以上版本hasVBA = workbook.HasVBProject;}else{//Excel2007以前版本foreach (VBComponent vbc in workbook.VBProject.VBComponents){if (vbc.CodeModule.CountOfLines > 0){hasVBA = true;break;}}}