在C#代码中编写宏操作Excel

Workbook oBook; Application oXlsApp; private void OpenExcelConnection()//创建workBook对象 { oXlsApp = new Application(); oXlsApp.Visible = false; // Excel表示有無 oXlsApp.DisplayAlerts = false; // Excelの確認ダイアログ表示有無 oBook = (oXlsApp.Workbooks.Open( excelFileName, // Filename Type.Missing, // UpdateLinks Type.Missing, // ReadOnly Type.Missing, // Format Type.Missing, // Password Type.Missing, // WriteResPassword Type.Missing, // IgnoreReadOnlyRecommended Type.Missing, // Origin Type.Missing, // Delimiter Type.Missing, // Editable Type.Missing, // Notify Type.Missing, // Converter Type.Missing, // AddToMru Type.Missing, // Local Type.Missing // CorruptLoad )); oSheet = (Worksheet)oBook.ActiveSheet; } private void CreateMacro()//创建宏 { try { VBIDE.VBComponent oModule; oModule = oBook.VBProject.VBComponents.Add(VBIDE.vbext_ComponentType.vbext_ct_StdModule); string sCode = @" Sub StyleChange() Application.DisplayAlerts = False Dim i, j, k, str, Sheet,