what is the difference between application window and workbook window?
Excel. Windows() lets your write to it [1], whereas Application. ... Other than the read-only distinction for the Application version, they are the same. So, if you're just reading properties, use the Application version, if you need to change something, use the Excel version.