Hi All, Can anybody tell me how to read the properties of a saved file using VBA. Specifically I want to read the date created property of an external file before continuing to import the data from that file into my current workbook.

Torrent Remembering The Kanji. I'm trying to pull the creation date of all the files (1000+) in a folder on a local server to list in an excel file. Get creation date of multiple files in vb.

This will form part of an error trapping procedure - ie not continue with the import if the external file has not been updated within a given period. This is probably very simple but I've searched the forum for the last hour without any success. Please be gentle with me, I'm very much a novice with VBA.