View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
webels webels is offline
external usenet poster
 
Posts: 44
Default Extracting date file modified from a text file.

Hi
As part of an error checking control step I would like to add some VBA
to a Macro which requires extracting the date of modification of a
text file.

Specifically I want to read the date modified property of an
external .txt file before continuing to import the data from that
file into my current workbook.

If this date modified property does not equal Todays date (Today()) I
want a message box to appear saying the File will not be imported as
it was not modified Today. I then want the Macro to be terminated. If
it does equal todays date - no message box and continue with the rest
of the Macro code.

Would anyone be able to help me with the coding of this

Thanks
Eddie