Sorry if this has been dealt with before - can't find it on a search.
I am using XP with SP1.
I want to create a spreadsheet listing the contents of various folders, mainly so I can identify gaps in downloaded series. Explorer gives me all the details I want, but I can't find a way to export all the information so it can be manipulated. So far I can only copy title information on one-by-one basis, and this is restricted to the file name.
Ideally I would like to capture information about the entire contents of a folder, paste it into Excel, then sort by file size, creation date, etc.
If you can find a Windows Explorer equivalent that will allow you to print or send the contents to a file then I'm sure we can find a way to import that data into Excel, using a macro or otherwise.
I am aware of Excel macros that list files within folders (in fact I've written and used them) but they don't include the details like file size etc. and tend to be limited to searching the folder that the Excel file is located in. I think that what you are after would be relatively difficult to do from within Excel VBA without API calls etc. and we (certainly I) would be on a steep learning curve.
I think that the underlying problem is that Windows Explorer won't give you a printout - I've never understood why. Equally I've never had the need to do this. However, I believe that there are ways of doing so.
If you can find a program that allows you to print (or better save) a folder list, it would be possible to do a "print to file" then an import to Excel. You might want to start a new thread without "Excel" in the title as this may put a lot of potential helpers off.