View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Get the date a file was modified

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.

--
Regards,
Tom Ogilvy

"JustinP" wrote in message
oups.com...
Is it possible to get the date when a file was last modified
programmatically in VBA?