The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Application.ActiveWorkbook Property

Office 2007
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.



expression   A variable that represents an Application object.


This example displays the name of the active workbook.

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

Community Additions

© 2015 Microsoft