Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for file in folder
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for file in folder
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for file in folder
Hi Dom,
done the trick, thanks very much.. Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check if all formula's in a column are linked to the same file/folder | Excel Discussion (Misc queries) | |||
Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
Check if folder exists, if yes just copy sheet in to folder? | Excel Programming | |||
How to check if a file exists in an ftp folder | Excel Discussion (Misc queries) | |||
check if file is in particular folder | Excel Programming |