Application.ActiveWorkbook Property

Syntax

expression.ActiveWorkbook

expression A variable that represents an Application object.

Example

This example displays the name of the active workbook.

Visual Basic for Applications
`MsgBox "The name of the active workbook is " & ActiveWorkbook.Name`

Active workbook Active Workbook Property ActiveWorkbook ActiveWorkbook Property ActiveWorkbook? Find out which workbook is currently active? Return the workbook in the active window?

Returns a Workbook object that represents the workbook in the active window (the window on top). Read-only. Returns Nothing if there are no windows open or if either the Info window or the Clipboard window is the active window.

See also: