Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Create a new workbook
Sub NewWorkbooks()
   Dim myWorkbook1 As Workbook
   Dim myWorkbook2 As Workbook
 
   Set myWorkbook1 = Workbooks.Add
   Set myWorkbook2 = Workbooks.Add
   Application.DisplayAlerts = False
   myWorkbook1.SaveAs FileName:="E:\SalesData1.xls"
End Sub