I am looking for a way to grab the file names in a directory (like my pics) and list them in a worksheet.

I am also interested in file details as well.

So the worksheet would look something like

thanksgiving 2008 001.jpg - 192K -
thanksgiving 2008 002.jpg - 253K -
...
yada yada yada

I think this could be done in with a macro but I don't have access to my vba books right now, and don't know the code that well to whip it out really quickly.

Any thoughts or ideas?