thisworkbook and activebook access without usign workbooks collection

[lezawang]

Hi
The code below is going to run no problem to my surprise. It will also run without typing Application. Now I am confused. I know to access a workbook I need to go through the workbook collection like the following

 msgbox(application.workbooks(1).name)

So why the code below is OK? Thank you very much.

Sub wk1()
   MsgBox (Application.ThisWorkbook.Name)
   MsgBox (Application.ActiveWorkbook.Name)
End Sub

 

[Jeffrey Mahoney]

You don't have to use Application when referencing the workbooks collection

This refers to the the workbook where this macro resides
msgbox Thisworkbook.name

refers to the workbook that is currently active. Could be the same
msgbox Activeworkbook.name

refers to the first opened workbook. Could be the same as either of the other two above.
msgbox Workbooks(1).name

Jeff