How to paste the date+time a different file was last modified into a cell?

[d0rian]

There's a CSV file at the path: C:\Users\Me\Documents\data_files\quotes.csv

I have a different file (mainfile.xlsm) open in which I want code that will fetch the date the quotes.csv file in the directory above was last modified, and paste it into cell A1. Anyone help? Thank you!

 

[mrshl9898]

Here you go:

Sub lastmod()

Range("A1")  = FileDateTime("[COLOR=#333333]C:\Users\Me\Documents\data_files\quotes.csv[/COLOR]")

End Sub

 

[d0rian]

perf, thx!