Difference between Thisworkbook.name and Activeworkbook.name in VBA
Is there any difference between Thisworkbook and ActiveWorkbook.
Example code :
Sub workbook_name() MsgBox Thisworkbook.name End Sub Sub active_name() MsgBox Activeworkbook.name End Sub
Both will return the same output,
Is there any other instances where we have to use particularly ThisWorkbook where ActiveWorkbook doesn't work
Activeworkbook.name is used to get the name of the active workbook from n different number of opened workbooks.
Thisworkbook.name is used to get the name of the workbook in which the code is written or stored in the module of that workbook.
E.g if you are writing the code in the module or sheet of workbook
Thisworkbook.name will return
A no matter which is the activeworkbook