The Workbook object is a member of the Workbooks collection. The Workbooks collection contains all Workbook objects currently open in Microsoft Excel. The ThisWorkbook property of the Application object returns the workbook where the Visual Basic code is coded.