Breaking News: Grepper is joining You.com. Read the official announcement!

Close excel amongs open another excel

Syah reza answered on August 18, 2022 Popularity 1/10 Helpfulness 1/10

answer Close excel amongs open another excel

Close excel amongs open another excel

Comment

System.Diagnostics.Process[] processes = System.Diagnostics.Process.GetProcesses("Excel");    
  foreach (Process p in processes)
  {
      if (p.MainWindowTitle == "MyFile.xlsx - Excel")
      {
          p.Kill();
          break;
      }
  }

and below code does nothing :

Microsoft.Office.Interop.Excel.Application xlApp = new icrosoft.Office.Interop.Excel.Application();
            Microsoft.Office.Interop.Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(path);
            //xlWorkbook.Close(false);

            xlWorkbook.Close(true, Type.Missing, Type.Missing);
            xlApp.Quit();
            System.Runtime.InteropServices.Marshal.ReleaseComObject(xlWorkbook);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp);
            xlWorkbook = null;
            xlApp = null;

            GC.Collect();

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: www.codeproject.com

Tags: excel whatever

Link to this answer
Share Copy Link