Excel template to create Folder/Subfolder List for mp3 albums

**stuartm456** · 07-07-2010, 10:37 AM

I'm looking for an excel template that would create a spreadsheet of my mp3 collection which is currently stored in folders of artist followed by album within that particular artist

Idealy the spreadsheet would have just 2 or 3 colums, 1 Artist, 2 Album and maybe a 3rd for the Disc (as some albums have 2 or 3 discs)

I currently have a Macro (xls file attached) which reads all the tags within my mp3 collection, but this includes track, file name, genre etc..., but as I don't have microsoft Visual Basic I am unable to edit it to suit my needs.

Any help would be much appreciated

Thanks

**dominicb** · 07-07-2010, 11:00 AM

Good afternoon stuartm456

...and welcome to the forum!!

First of all, Excel comes with a version of Visual Basic called VBA. You can access it through the Visual Basic Environment (press Alt and F11 to open this up).

A template for this is available via John Walkenbach's site - I've never actually used it, but it seems to tick the boxes that you've identified and may be a starting point :
http://spreadsheetpage.com/index.php...lister_posted/

HTH

DominicB

**stuartm456** · 07-07-2010, 12:03 PM

Hi, thanks for the help,

I have a VBA code to create a list of folders and subfolders but can not get it programmed in, when i attempt to enter VB environment i've been getting the error "vb6ext.olb could not be loaded", i just presumed it was due to not having Microsoft Visual Basic on my PC???

The link you've given me is for the same template as the 1 i've been using, i thought maybe there would be a similar template around that would just create a list of folders and subfolders from a specific directory. which is really what i'm after.

this error "vb6ext.olb could not be loaded" is getting on my **** (wick), any ideas what it is?, when i press ok, i then get "memory could not be loaded"

thanks again.

**Leith Ross** · 07-07-2010, 12:18 PM

Hello stuartm456,

It may be due to the declarations in the FileInfo function. The Shell32 library would need to be loaded for the Dim statements to work. You don't have to explicitly declare the objects by type. The objects can be declared generically like this...

Please Login or Register  to view this content.

**stuartm456** · 07-07-2010, 12:34 PM

I'm totally lost!!!

**Leith Ross** · 07-07-2010, 12:58 PM

Hello stuartm456,

If you have Microsoft Office on your machine then you should have VBA as well. It is possible that the file has been corrupted and needs to be reloaded. You would need the your Office installation disk to reload VBA.

**shabbak** · 02-27-2014, 10:27 AM

This is fantastic.

I have bought programes to list songs in folders that are not as good as this.

Excellent

Steve

Originally Posted by dominicb

Good afternoon stuartm456

...and welcome to the forum!!

First of all, Excel comes with a version of Visual Basic called VBA. You can access it through the Visual Basic Environment (press Alt and F11 to open this up).

A template for this is available via John Walkenbach's site - I've never actually used it, but it seems to tick the boxes that you've identified and may be a starting point :
http://spreadsheetpage.com/index.php...lister_posted/

HTH

DominicB