Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Overwriting an Existing Workbook
Sub add()
     Set myWorkbook1 = Workbooks.Add
     Application.DisplayAlerts = False
     myWorkbook1.SaveAs Filename:="C:\Data\SalesData1.xlsx"
     Application.DisplayAlerts = True
End Sub