ThisWorkbook or ActiveWorkbook ?
ActiveWorkbook refers to the workbook that is currently in the active window.
ThisWorkbook refers to the workbook where the code is actually running from.
No matter where the workbook is saved ThisWorkbook.Path always returns the current location of the file.
Activating and Selecting
Can be used if the workbook is new and has not yet been saved.
assuming that the workbook has been saved
This refers to the workbook that contains the code.
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext