{"id":516,"date":"2013-03-03T13:47:02","date_gmt":"2013-03-03T13:47:02","guid":{"rendered":"http:\/\/excelvbatutor.com\/?page_id=516"},"modified":"2020-04-23T10:57:28","modified_gmt":"2020-04-23T10:57:28","slug":"excel-vba-lesson-21-the-workbook-object","status":"publish","type":"page","link":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-lesson-21-the-workbook-object\/","title":{"rendered":"Excel VBA Lesson 21: The Workbook Object"},"content":{"rendered":"\n

<<Lesson 20>><\/a> [Contents]<\/a> <<Lesson 22>><\/a><\/strong><\/h4>\n\n\n\n

In the previous lesson, we have learned to write code associated with the worksheet object. In this lesson, we shall learn about the Workbook object. The Workbook object at the top of the hierarchy of the Excel VBA objects. We will deal with properties and methods associated the Workbook object.<\/p>\n\n\n\n

21.1 The Workbook Properties<\/strong><\/h3>\n\n\n\n

When we write Excel VBA code involving the Workbook object, we use Workbooks. The reason is that we are dealing with a collection of workbooks most of the time, so using Workbooks enables us to manipulate multiple workbooks at the same time.When will deal with multiple workbooks, we can use indices to denote different workbooks that are open, using the syntax Workbooks (i), where i is an index. For example, Workbooks (1) denotes Workbook1, Workbooks (2) denotes Workbook2 and more.Workbooks have a number of properties. Some of the common properties are Name, Path and FullName Let\u2019s look at the following example:<\/p>\n\n\n\n