Data Type VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Data Type
  4. VBA knows that anything starting with a period is a property or a method of the object following the With
Sub NewWorkbook()
       Dim myWorksheet As Worksheet
       With Workbooks.Add
         Set myWorksheet = .Worksheets.Add(After:=.Sheets(.Sheets.Count))
         myWorksheet.Name = "January"
         myWorksheet.Range("A1").Value = "Sales Data"
         .SaveAs Filename:="YourExcel2007File.xlsx"
       End With
     End Sub