This is excellent. I have been looking for a way to get a list of files in a directory into Excel so that I can determine which are new. The contents change over time. I found this here

I put the following code from ask.metafilter.com into the module of my file (using Alt+F11). I can now play with the code to give me the file attributes I need. This code will give you Filename, Size, Created, Modified , Accessed, Full path.

Option Explicit
Sub GetFileList()
Read more »