Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Add a new workbook and save it
Public Sub SaveActiveWorkbook()
  Application.Workbooks.Add
  Call Application.ActiveWorkbook.SaveAs("temp.xls")
End Sub