Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with ThisWorkbook | Excel Programming | |||
Help with ThisWorkbook | Excel Programming | |||
ActiveWorkBook | Excel Discussion (Misc queries) | |||
ThisWorkbook vs. ActiveWorkbook? | Excel Programming | |||
ThisWorkbook | Excel Programming |