Check for file in folder

[Les Stout]

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

 

[dolivastro]

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]

Hi Dom,

done the trick, thanks very much..

Les Stout