ThisWorkbook/ActiveWorkbook
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
|