Help with MS-XLS?

Use visual basic to create a file system object. Then using that file system object, collect a list of drives first. You can skip this if all your audio files are on only one drive. Then collect a list of folders within the drive. You may need to write code to account for sub directories as well. Finally using the file system object, collect a list of file names and sizes for each file that has the extension that would indicate that it is an audio file. This can be done as a macro within Excel. See links below: