J JustinP Sep 5, 2006 #1 Is it possible to get the date when a file was last modified programmatically in VBA?
T Tom Ogilvy Sep 5, 2006 #2 filedatetime but not the workbook that is open - that always has the date and time when it was opened. It you open it read only I believe it will have its last saved time.
filedatetime but not the workbook that is open - that always has the date and time when it was opened. It you open it read only I believe it will have its last saved time.
B Bob O`Bob Sep 5, 2006 #3 JustinP said: Is it possible to get the date when a file was last modified programmatically in VBA? Click to expand... Using a FileSystemObject, the GetFile method will return a File object, from which you can query the DateLastModified property. Bob --
JustinP said: Is it possible to get the date when a file was last modified programmatically in VBA? Click to expand... Using a FileSystemObject, the GetFile method will return a File object, from which you can query the DateLastModified property. Bob --
