Ejemplo n.º 1
0
        public static void SaveAsLNSchedule()
        {
            Console.Clear();
            try
            {
                clsConsole.WriteLine("\r\n Complete saving as Schedule ...", ConsoleColor.Red);
                WorkbookExcel.SaveAs(LNSchedule, SaveAsExcelFormat, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing);
            }
            catch (Exception)
            {
                clsConsole.WriteLine("\r\n Complete saving Copy of Schedule ...", ConsoleColor.Red);
                WorkbookExcel.SaveAs(CopyofLNSchedule, SaveAsExcelFormat, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing);
                ScheduleCopyExisted = true;
            }

            WorkbookExcel.Close();

            ExcelApp.Quit();
        }