Microsoft Workbook

-->

A collection of all the Workbook objects that are currently open in the Microsoft Excel application. For more information about using a single Workbook object, see the Workbook object. Mari samuelsen vivaldi. Use the Workbooks property of the Application object to return the Workbooks collection. The following example closes all open workbooks. The Workbook Visualization The workbook will show by default four groups. Each group has five variables: group, title, subscription picker, overall secure score, secure score per subscription.

Represents a Microsoft Excel workbook.

Remarks

The Workbook object is a member of the Workbooks collection. The Workbooks collection contains all the Workbook objects currently open in Microsoft Excel.

The ThisWorkbook property of the Application object returns the workbook where the Visual Basic code is running. In most cases, this is the same as the active workbook. However, if the Visual Basic code is part of an add-in, the ThisWorkbook property won't return the active workbook. In this case, the active workbook is the workbook calling the add-in, whereas the ThisWorkbook property returns the add-in workbook.

A workbook is another word for your Excel file. When you start Excel, click Blank workbook to create an Excel workbook from scratch. Open an Existing Workbook. To open a workbook you've created in the past, execute the following steps. On the File tab, click Open. Recent shows you a list of your recently used workbooks. Download this app from Microsoft Store for Windows 10, Windows 8.1. See screenshots, read the latest customer reviews, and compare ratings for My Workbook. Create a new whiteboard and collaborate with others at the same time. Bring ideas, content and people together – from your computer, phone or tablet.

Microsoft Workbook

If you are creating an add-in from your Visual Basic code, you should use the ThisWorkbook property to qualify any statement that must be run on the workbook that you compile into the add-in.

Microsoft Workbook Download

Example

Use Workbooks (index), where index is the workbook name or index number, to return a single Workbook object. The following example activates workbook one.

The index number denotes the order in which the workbooks were opened or created. Workbooks(1) is the first workbook created, and Workbooks(Workbooks.Count) is the last one created. Activating a workbook doesn't change its index number. All workbooks are included in the index count, even if they are hidden.


The Name property returns the workbook name. You cannot set the name by using this property; if you need to change the name, use the SaveAs method to save the workbook under a different name.

The following example activates Sheet1 in the workbook named Cogs.xls (the workbook must already be open in Microsoft Excel).


The ActiveWorkbook property of the Application object returns the workbook that's currently active. The following example sets the name of the author for the active workbook.


This example emails a worksheet tab from the active workbook by using a specified email address and subject. To run this code, the active worksheet must contain the email address in cell A1, the subject in cell B1, and the name of the worksheet to send in cell C1.

Events

Methods

Properties

Microsoft Workbook Vs Worksheet

See also

Excel For Dummies Free Tutorial

Support and feedback

Microsoft Workbook Laptop

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.