Share via


_Application.ThisWorkbook Property

Returns a Workbook object that represents the workbook where the current macro code is running.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
ReadOnly Property ThisWorkbook As Workbook
    Get
'Usage
Dim instance As _Application
Dim value As Workbook

value = instance.ThisWorkbook
Workbook ThisWorkbook { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Workbook

Remarks

Use this property to refer to the workbook that contains your macro code. ThisWorkbook is the only way to refer to an add-in workbook from inside the add-in itself. The ActiveWorkbook property doesn't return the add-in workbook; it returns the workbook that's calling the add-in. The Workbooks property may fail, because the workbook name probably changed when you created the add-in. ThisWorkbook always returns the workbook in which the code is running.

This property can be used only from inside Microsoft Excel. You cannot use it to access a workbook from any other application.

See Also

Reference

_Application Interface

_Application Members

Microsoft.Office.Interop.Excel Namespace