View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default 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