Reading file's date stamp into VBA

[vbacoder]

Hi Everyone,

Is there a way to read the date stamp on a file (i.e. the time that it was last saved) into my code, so I can introduce a condition to only open a file if it was created/last saved on a certain date?

Many thanks,

vcoder

 

[Lewiy]

See if this gives you what you need:
http://www.mrexcel.com/board2/viewtopic.php?t=289032&highlight=

 

[vbacoder]

Hi Lewiy,

Thanks very much indeed! I like the code and I'll put it into action tomorrow.

Many thanks,

vcoder