Thread: Date Last Saved
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Craig[_6_] Craig[_6_] is offline
external usenet poster
 
Posts: 1
Default Date Last Saved

Does anyone know how to access the "Date Last Saved"
attribute of a file using VB Code? I want to display the
latest date the file was saved in a footer when printed,
not necessarily the current date or file creation date.
Because Excel is designed to change the modified date of a
file when it is opened (the original modify date is held
in memory and restored if you don't save changes), I can't
use the ".DateLastModified attribute. Any suggestions?