title: refresh and save excel file via c#
body: <p>I use this code to open refresh save and close excel file:</p>
  
  <pre><code>Application excelFile = new Application();               
  Workbook theWorkbook = excelFile.Workbooks._Open(Environment.CurrentDirectory + "/WebGate", 0, false, 5, System.Reflection.Missing.Value, System.Reflection.Missing.Value, false, System.Reflection.Missing.Value, System.Reflection.Missing.Value, true, false, System.Reflection.Missing.Value, false);    
  Sheets sheets = (Sheets)theWorkbook.Worksheets;    
  theWorkbook.RefreshAll();    
  theWorkbook.Save();    
  excelFile.Quit();
  </code></pre>
  
  <p>the problem is that there is a conflict between the refresh and save commands because the file is been save while the refresh is been done in the background (I guess)
  can anyone help me with this? i need to know how can I know when the refresh proccess is done  or any other indication that will help my to decide when should I save the file without harm the refresh proccess </p>