The difference between "ThisWorkbook" and "ActiveWorkbook" refers to the workbook that is currently in the active window, whereas "ThisWorkbooK" refers to the workbook where the code is actually running from.
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.
This is always the workbook that contain the code.
This is the worksheet that is currently active or selected
ActiveWorkbook.Path = "C:\Temp"
ActiveWorkbook.Name = "Book2"
objWorkbook.CreateBackup = False
There is only a folder path when the workbook has been saved
This property is equivalent to the Path property, followed by the current file system separator, followed by the Name property.
Determines the version of a workbook, i.e. which version of Excel created this workbook.
16 = Excel 2
29 = Excel 3
33 = Excel 5
39 = Excel 5/96
-4143 = Excel 97/2000/2002/2003
undo the last action performed by the user interface.
Returns the collection of recently opened files
Read-only returns an object allowing manipulation of the office assistant.
Some of the content in this topic may not be applicable to some languages.
There's only one Answer Wizard per application, and all changes to the AnswerWizard or the AnswerWizardFiles collection affect the active Office application immediately.
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext