Possible via vba to check the datetime stamps on files in a directory?

[Salient]

Must admit to not having got stuck into this requirement yet so maybe should have checked the functions etc.

Basically I want to check a directory to see if a file has been written into it in the last half an hour by another process. One of those watchdog processes.

Anyways is this possible?

[Paul_Hossler]

http://www.cpearson.com/excel/FileTimes.htm


Chip's always got a lot of useful stuff on his site

Paul

[snb]

[VBA]msgbox filedatetime("G:\OF\files.xls")[/VBA]

[Bob Phillips]

It sounds as if you need a combination of a macro that looks at all of the files in a nominated directory using Dir to get each file, and OnTime to fire the macro at preset intervals.

[Kenneth Hobs]

OnTime or a Windows Scheduled task might be methods that you could use for VBA code. The OnTime method might work for you: http://www.mrexcel.com/forum/showthr...tcher-possible

For something like that, I would probably use vb.net. I gave a lesson on how to do that at: http://www.wpuniverse.com/vb/showthr...ht=watchfolder

If you don't want to register for free at WordPerfect Universe to see this lesson and my other vb.net lessons, explore these vb.net links on the topic:
http://msdn.microsoft.com/en-us/libr...emwatcher.aspx
http://www.vbdotnetheaven.com/upload...rol-in-VB-Net/
http://www.codeproject.com/KB/dotnet/folderwatcher.aspx
http://www.developerfusion.com/artic...ty-in-vbnet/2/

Depending on your need, there are some ShellWait routines that can wait on a process, such as writing to a large text file, to complete before continuing on.