If anybody is interested…

I’ve put together an excel spreadsheet with some visual basic code that I use for printing a list of the songs on the empeg. It reads the csv file exported from emplode and arranges the tracks by genre, artist and album in a format suitable for printing. I usually produce a one-page list of the artists, and (currently) an 18-page list of the 8700 songs. The number of artists or songs per page (and therefore the size of the type) can be controlled by parameters.

Without the printed lists I would completely forget about some of the music I have. Plus, it gives me a physical way to overwhelm my friends with the amount of music I have in my car stereo…

I use it for other things as well. I can also print a list of all the music on my hard drive or just the tracks on my hard drive that are missing from the empeg. But, I didn’t make that very generic, so it only works if you happen to store all your music files as ..\artist\album\artist – album – track.mp3.

Take a look at the attached and see if it’s useful to you. I threw some comments into it to document how it works. Feel free to do anything you want with it and let me know if you have any suggestions or comments.

Thanks,
Bill