Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. To add an existing workbook file to the Workbooks collection, you use the Open method
Sub open()
     Set myWorkbook1 = Workbooks.Open(Filename:="C:\Data\SalesData1.xlsx")
End Sub