Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ThisWorkbook/ActiveWorkbook
Thisworkbook is always the workbook within which the macro is stored. Activeworkbook is any member of the Workbooks collection - activated by Workbooks(xx).activate :) -- chubster264 ------------------------------------------------------------------------ chubster264's Profile: http://www.excelforum.com/member.php...o&userid=30164 View this thread: http://www.excelforum.com/showthread...hreadid=510304 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |