Capture file date of external file

[rrrdavis07]

Hey guys, I hope someone can help.

I've written a macro that pulls in data from a CSV file in Excel and formats it. Is there a way to capture the file date/time of the csv file? I want to be able to use it to display the age of the data.

Randy Davis
Denver, CO

 

[SkipVought]

Hi,

Check out the File Object of the FileSystemObject object. The File Object has a DateCreated property.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[PHV]

No need of external object:
MyStamp = FileDateTime("\path\to\yourfile.csv")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886