New MP3 question

[chefwarren]

Hi All,

Me again. I am just addicted to this site. So here is my newest challenge. I have searched through the archives and have not found exactly what I am looking for so new post.

I would like to create an excell list of all my music.

My music is stored on an external hard drives in one master folder called aptly my music, and hundreds of folders within by artist name. Some of those folders have further folders that are Album title, finally files stored within.

Is there away to run a macro that will search each folder, find the files, extract the atist name, song title, album etc.

Kindly,

Warren

 

[jstiene]

With Andrew Fergus' solutions, I get an error at the following line of code.


I like the information that this solution is supposed to provide but get the same error as above.


Not sure if it matters, but I'm running excel 07 on XP. I read on the above website that I needed to enable shell32.dll under VB resources, but find it grayed out. Any ideas?

TIA

You know Filesearch is not even allowed in Office 2010. One more knife in the back from our pals at MS. You need workarounds for any filesearch in Excel, Access, etc.