VBA to Find File Last Modified Date

Опубликовано: 07 Февраль 2023
на канале: OfficeTricks

2,184

How to find File Last Modified Date using VBA code?
If there is a need to access the file that was last modified or updated in a folder, then programmer has to find the last modified date from the file properties.
This can be done in VBA using one of these 2 methods.
Use one these 2 simple methods to find the file Last modified date using build in functions with in VBA code & by using file system object.

The second VBA function not only gives the modified date, but also gives the file creation date and last accessed date.
It might be little confusing to understand the difference between the last modified date and last accessed date. Last accessed is the date when someone open the file, sees its content and closes the file without any modifications to it. If anything gets modified and saved, then that date gets updated to last modified date parameter.

Смотрите видео VBA to Find File Last Modified Date онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь OfficeTricks 07 Февраль 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,184 раз и оно понравилось 9 людям.

785