Yip

[nabbster]

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.

[eSPiYa]

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

[nabbster]

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

[nabbster]

Any Takers?

[eSPiYa]

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