modified date

[ceemo]

hi all,

Is it possible to check the modified date/time of either an xls or csv file on a floppy disk and then execute a module if the modified date/time is within a certain time frame?

[Bob Phillips]

You can use FileDateTime

Ans = filedatetime ("C:\mytest\volker1.xls")
If Date - DateValue(ans) < 10 Then 'less than 10 days old
myMacro
...

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ceemo" <[email protected]> wrote in
message news:[email protected]...
>
> hi all,
>
> Is it possible to check the modified date/time of either an xls or csv
> file on a floppy disk and then execute a module if the modified
> date/time is within a certain time frame?
>
>
> --
> ceemo
> ------------------------------------------------------------------------
> ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
> View this thread: http://www.excelforum.com/showthread...hreadid=480365
>