How can I export a list of files on a data disc into Microsoft Excel?

Question

I know there has to be a way to do this. I want to be able to print out a spreadsheet with these file names in them. Thanks for your help!

Answer 1

Most anything is possible through VBA, but you could do this easily through a DOS command if you are wanting to create a new Excel file with the filenames.

If your data disc is a cd in drive d:

Open a command prompt (start->run->cmd.exe)

type this command:
dir /s /b d:\ >c:\filename.xls

This will output all files and directories from drive d: including all subdirectories (the "/s" part of the command) to a file called "filename.xls" on your root c: directory.

Make sure # files does not go past Excel's limit of approx 65,000 lines.