Getting date downloaded from text file (1 Viewer)

[David b]

I download a text file and save it on the desktop. My app imports the data from the text file and compares it with data already stored and advises of discrepancys.
Is it possible to get the date created from the text file so that the user can see when the last download was ?
David b

 

[ghudson]

Using the FileDateTime function will allow you to get the date the file was created or last updated. Check the help files for the FileDateTime Function more info and examples.

HTH

 

[David b]

That`s brilliant. Thanks
David b

 

[David b]

Next question is what if the txt file does not exist. Instead of "#error" I could do with an explaination displayed in the text box
David b

 

[ghudson]

This should get you on the right track...

    If Dir("C:\Temp\test.txt") <> "" Then
        MsgBox "File does exist"
        MsgBox FileDateTime("C:\Temp\test.txt")
    Else
        MsgBox "File does not exist"
    End If

HTH

 

[David b]

That`s great. Thanks again.

BTW still can not get that save and zip to A:\ routine from last week to run.

David b