I need to import a CSV file with the date stamp of the CSV file appended to each row. These dates do not exist within the CSV file. I've not been able to figure out how to do this, so can anyone give me some direction on where to look? Thanks
I need to import a CSV file with the date stamp of the CSV file appended to each row. These dates do not exist within the CSV file. I've not been able to figure out how to do this, so can anyone give me some direction on where to look? Thanks
Welcome to the forum......
Check out the function "FileDateTime" in HELP.
Result is -> 2/12/2018 9:49:04 PMCode:Public Sub timedate() Dim theFileDate As Date theFileDate = FileDateTime("C:\Pullman.csv") Debug.Print theFileDate End Sub