Hi all, i need to check a folder in a network drive "Q" to see if a file
exists, if it does, when was it created if older than 7 days give a
message are you sure you want to use this file, if younger than 7 days
open.

Some help with code would be appreciated.

Thanks in advance for any help..

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Use the FileDateTime (<file>) function:

if (now() - FileDateTime (<file>)) > 7) then
call MsgBox ("Your message")
else
[code...]
end if

Hope this helps,
Dom




Les Stout wrote:
> Hi all, i need to check a folder in a network drive "Q" to see if a file
> exists, if it does, when was it created if older than 7 days give a
> message are you sure you want to use this file, if younger than 7 days
> open.
>
> Some help with code would be appreciated.
>
> Thanks in advance for any help..
>
> Les Stout
>
> *** Sent via Developersdex http://www.developersdex.com ***

Hi Dom,

done the trick, thanks very much..

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***