Determine create date of imported file

All,

I have created a macro that combines all tab delimited text files within a specified folder into one master file (Excel). I would like to name this file "Master" & "doff" where "doff" is the date that the first file to be imported was created or last modified as viewed by the operating system. Is this possible in Excel VBA? Thanks!

Hello St4rcutter,

Here is macro to return the creation date of the file you choose. The macro requires the path and file name, i.e. "C:\My file.xls". Place this code in a Standard VBA Module.

Please Login or Register  to view this content.

Call the macro this way...
creationDate = GetFileCreationDate "C:\My File.xls"

Sincerely,
Leith Ross

Fantastic!!!! Thank you Leith.