title: Use vbs to open an excel workbook, run a macro and save the workbook
body: <ul>
  <li>I have a macro that I need to be run every 5 min. I have a <code>vbs</code> file that schedules the macro.</li>
  <li>The macro is checking for new files in some folder, writes their info into a table, and moving the files into archive.</li>
  <li>The table is in the same excel file as the macro!</li>
  </ul>
  
  <p>It is running the macro fine but in the end, its asking me if I wont to save the file. </p>
  
  <p>I need it to save the changes that the macro did to the file automatically!</p>
  
  <p>this is my current <code>vbs</code> code:</p>
  
  <pre><code>Option Explicit
  
  Dim xlApp, xlBook
  
  Set xlApp = CreateObject("Excel.Application")
  xlApp.DisplayAlerts = False
  Set xlBook = xlApp.Workbooks.Open("W:\Excel Macro\EIM File Maneger\EIM_file_check.xlsm", 0, True)
  
  xlApp.Run "GetFiles"
  
  xlBook.Close true
  xlApp.Quit
  
  Set xlBook = Nothing
  Set xlApp = Nothing
  
  WScript.Echo "Finished."
  WScript.Quit
  </code></pre>