title: How to Save Excel without an user prompt to save the file?
body: <p>Hi I wrote some code using VBScript on Excel sheet as below. Now everytime when the Script is done its processing it is prompting the user to <code>Save</code> it.But I don't want this,rather I want it to save it automatically without prompt.</p>
  
  <p><strong>CODE</strong></p>
  
  <pre><code>    Option Explicit
  
      Dim objExcel1,strPathExcel1,objSheet1,objSheet5
  
      Set objExcel1 = CreateObject("Excel.Application")'Object for Condition Dump
      strPathExcel1 = "D:\VA\GE_Wing_To_Wing_Report.xlsx"
      objExcel1.Workbooks.Open strPathExcel1
      Set objSheet1 = objExcel1.ActiveWorkbook.Worksheets(1)
      Set objSheet5 = objExcel1.ActiveWorkbook.Worksheets(5)
  
      '=====================================================================================
      'Here Bad sheet will be copied by the data from First sheet master data sheet
      '=====================================================================================
         ParentPIDFromMasterSheet objSheet1,objSheet5
  
      '=====================================================================================
      'Here Bad sheet will be copied by the data from First sheet master data sheet
      '=====================================================================================
         BadDataSelectionDel objSheet5
  
      '=======================
      objExcel1.ActiveWorkbook.SaveAs strPathExcel1
      objExcel1.Workbooks.close
      objExcel1.Application.Quit
      '======================
  </code></pre>