Yip

Hi guys sorry its me again but i am completley stumpped
i wrote this program which parses a server log for data then works on the resulting data.
this whole thing was based on the server log being replaced once a week so once a week i would manually update the log with new file name.
just found an instance when the log could be updated with a new log maybe 10x in 1 hour is there any simple way to check if a new log exists they allways run sequencually 000001, 000002 and so on i want to keep it simple if possible as i am ready to run this thing.

thanks in advance oh btw download is via ftp i would presume this to be relavent i have looked on the forum but all i can see is exe updats based on file version.

I think the best way is check by date.
Then store the last date after checking to the database, textfile, or etc.

ok found some code that might work but how to use it on a remote file via ftp?


Dim lFso As Object, lf As Object

Set lFso = CreateObject("Scripting.FileSystemObject")

Set lf = lFso.GetFile("C:\test.log") 'Any sort of file

MsgBox "Date Last Modified: " & lf.DateLastModified
MsgBox "Date Last Accessed: " & lf.DateLastAccessed
MsgBox "Date Created: " & lf.DateCreated

Set lf = Nothing
Set lFso = Nothing

Any Takers?

I'm sorry but I haven't tried FTP.
Try this one.
I hope this may help you. ;)