Thread: ThisWorkbook/ActiveWorkbook

What is the difference in using:
ThisWorkbook.Path
-vs-
ActiveWorkbook.Path

Or any of the other Properties or Methods that can follow.


--
Regards,
John

ThisWorkBook object refers to the workbook that the code is contained in


ActiveWorkBook object refers to the workbook that is currently on top
(Active) in Excel


They can return the same object, but if the workbook running the code is not
the active workbook then they will return different objects.

--
When you lose your mind, you free your life.


"John Keith" wrote:

> What is the difference in using:
> ThisWorkbook.Path
> -vs-
> ActiveWorkbook.Path
>
> Or any of the other Properties or Methods that can follow.
>
>
> --
> Regards,
> John

Thisworkbook is always the workbook within which the macro is stored. Activeworkbook is any member of the Workbooks collection - activated by Workbooks(xx).activate