Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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