Edit MP3 tags in Excel / VBA

[MrTinkertrain]

Hello all,

I've been busy trying to figure out how to edit MP3 tags in Excel/VBA.
I've found a method which makes use of a DLL-file called cddbcontrol.dll.
Here's the code which is working for me :

Sub MP3TagChange()
Sheets("MP3tags").Select
Dim id3 As New CddbID3Tag
id3.LoadFromFile Range("A2").Value, False
id3.Album = Range("B2").Value
id3.Title = Range("E2").Value
id3.LeadArtist = Range("F2").Value
id3.Year = Range("G2").Value
id3.Genre = Range("H2").Value
id3.TrackPosition = Range("I2").Value
id3.SaveToFile Range("A2").Value
End Sub

In A2 I have the full path to a MP3-file.
This code is working and the changes are being made to that file.

What I'd like to do is to change this code, so that it changes the tags for all the Mp3's which are listed in Col A.
I hope someone can help me out on this one..

Thanks in advance,
Mike

 

[BrianB]

Have a look my code here :-
http://www.mrexcel.com/board2/viewtopic.php?t=1583222

 

[MrTinkertrain]

It says topic not found when I click your link

 

[BrianB]

Sorry - it's :-

http://www.mrexcel.com/forum/showthread.php?t=322393