MP3 File Info Details

I need some help with trying to extract details from MP3 files that I use for work purposes.

I have a library of over 900 MP3 tracks and I found the attached excel file that runs a macro which reads a music folder and extracts details of the MP3 tracks. There is one parameter that I need to extract but I'm unsure what string I need to use. I need to extract the composer details. The file has the following code that extracts the other details I require.

Please Login or Register  to view this content.

I've tried every number between 1 and 100 after 'filename' but none extract the composer details. I know the composer details exist in the metadata of the file as it lists the composers when I view the MP3 file properties in windows explorer. I tried to attach a short MP3 to this post, but got invalid file.

If anybody can assist me with this then that would be much appreciated.

The original author of the xls file requests on their webpage for no contact for help with their files, but states he is happy for people to freely use the file.

Cheers
Harry

Hi,

It's rather difficult to comment unless we have at least one of the files that contains the data. Please upload that too.

Hi,

I understand that but without having one of the files we aren't able to step through the macro in order to work out what needs changing in order to extract the composer details.

Hello kiwi_harry,

This macro will list all the MP3 with the information you have listed. It creates a header row in row 1 and then lists the files from row 2 down.

Be sure to change the fodler path to where your files are located. It is highlighted in blue font in the macro.

Please Login or Register  to view this content.

Hi,

The composer is embedded in the file name string. Try this small adapation of Leith's code which adds the composer as the last column.

Please Login or Register  to view this content.

Hello Harry,

Here is a utility macro I created to list the index numbers and file details. They have changed from time to time depending on which version of Windows your are running.

Please Login or Register  to view this content.

@Kiwi - I see you are now using the CODE tags correctly, thanks for that. I've added the missing ones to post #1. Carry on...

See: https://www.msofficeforums.com/159836-post3.html. In addition to outputting all possible attributes, the code there outputs the attribute headers.

Hi Dimitris and welcome to the forum.

Good to see you've used the Search functionality and found this 7 year old file, not many do.

We like people to start their own threads rather than picking up on existing threads, that can just cause confusion in the middle of a series of questions and answers, particularly where circumstances and data may be slightly different.
In addition those who were parties to the original thread may not be here anymore.

Admittedly neither of those apply in your case, nevertheless can I suggest you start a new thread and include a link to this thread for reference.

Originally Posted by dimitris152

Also something else. Is there a way to get excel to let me choose the file via message box instead of giving it a set folder path?

As I said. Create your own new thread.

Your 'also something else' demonstrates the point that hijacking a thread with your own special requirement gets confusing and is contrary to our rules.

I don't expect to see any more responses here which address your special variation. Please note.