Excel Vba Read Mp3 Tags Album Cover Art Dimensions
With this awarding, I recall that I am finishing the topic of list folders/files with Excel and VBA. An event that started with Folders, Subfolders, and Files and connected with Motility Files To Subfolders. So, with this workbook, y'all can quickly create a list of your MP3 files. Past creating an index of your MP3 files is much quicker to find a specific vocal; Excel search is much faster than hard disc search. For your ease, every time that the application detects a new artist or a new album, it highlights the advisable cell with red or blue colour correspondingly. This means that the highlighted cells contain all the unique artists and the unique albums that are included in the folder you selected. Moreover, the filters on each sheet volition assist y'all find the duplicate songs of your music collection.
The application is based on the GetDetailsOf method of VBA to become the properties of MP3 files. Unfortunately, no affair how hard I tried, I did not manage to notice a way to edit the MP3 tags and save the modified tags dorsum to the MP3 files (i.e., to do the exact opposite from this awarding). I tried even with external DLL libraries like CDDBControl.dll and CDDBControlRoxio.dll,
but I could only write one edited MP3 tag at a time, before Excel crashes.Bear in mind that the simple ID3v1 tags tin can exist edited with Excel if the MP3 files are treated as binary files. However, I decided not to include this pick here because almost MP3 files have ID3v2 tags that the application wouldn't be able to edit. Yous can detect numerous freeware MP3 programs that tin alter your MP3 tags on the net. So, although this application only reads MP3 tags, I believe that is withal quite useful for organizing your music drove.
How to utilize it
The short video below demonstrates the awarding in use.
Download it from here
This file tin can be opened with Part 2007 or newer. Information technology could be opened even with older Office versions that incorporate the compatibility pack from Microsoft. Nonetheless, do not forget to enable macros before using information technology.
Update 14/10/2012
Harm from Kingdom of the netherlands asked me if it is possible to attach the cover of each MP3 on the list that this small application creates. Well, as far as I am concerned, there is no fashion to get the artwork that it is stored on an MP3 tag past using VBA code. Yet, there is some kind of substitute for this.
My MP3 drove is organized similar this:
- Artist (ex. Dream Theater)
- Album (ex. 1992 – Images And Words)
- In each album (folder) I have a JPG image with the name "Folder," so that windows tin can recognize information technology and create a thumbnail of the album with that moving-picture show. In this way, you tin can view the artwork of the album when you lot are browsing through your folders (see the image beneath).
This excel file "Read MP3 Tags (With Artwork)" reads from each folder the picture with proper noun "Folder.jpg" and inserts it in each file of the folder every bit a comment. So, if y'all run the program at the fifth cavalcade (album) of the excel canvas a comment is inserted with the artwork (see next effigy). If in that location is no motion-picture show, no comment will be added.
And then, in case you take organized your MP3s using this "Binder.jpg" technique, you lot will exist able to see the album's artwork as a comment. Of course, this doesn't work on collections; if you lot have songs from various artists in a binder, then you will accept the same prototype in all songs since you cannot have multiple instances of "Folder.jpg" in the same folder.
Download information technology from here
You lot can open up it with the same versions as the above file.
Read also
Page concluding modified: January 6, 2019
welchexceplicted1970.blogspot.com
Source: https://myengineeringworld.net/2012/08/read-mp3-tags.html
0 Response to "Excel Vba Read Mp3 Tags Album Cover Art Dimensions"
Post a Comment