Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting file name and Modified date | Excel Programming | |||
insert the date the file was last modified | Excel Discussion (Misc queries) | |||
Last modified date of a linked file | Excel Discussion (Misc queries) | |||
date file modified | Excel Discussion (Misc queries) | |||
Get the date a file was modified | Excel Programming |