Excel 2007 : Read & Write Mp3 File Tag Properties Using Excel

**vivekhalder** · 10-08-2011, 07:04 AM

Hello,

I need a macro which will Read & Write MP3 tags.

Macro which will....

1. Browse MP3 files or folders (with subfolders) & Read the tags from it & copy it in to excel.

2. Write the edited tags from the excel to the selected MP3 files or folders.

Would be nice of you to post the macro in a excel file as a attachment.

Thanks in advance,
vivekhalder

**JBeaucaire** · 10-08-2011, 12:20 PM

That's a pretty specialized need. Do a Google search on "Excel VBA MP3 tags" and you'll get lots of ready-to-try links.

**dominicb** · 10-08-2011, 06:01 PM

Good evening vivekhalder

John Walkenbach has a file available for download that does what you ask, apart from (I think) the writing of data into the MP3 tags. His code is unprotected so you can examine / amend it as you wish.

The narrative is here.
You can download the workbook from here.

HTH

DominicB

**vivekhalder** · 10-09-2011, 03:11 AM

Hello John

Thanks for the link of the excel. But this only reads the mp3 tags.

Found a read & write macro but could not get how to amend that so would request to create a excel based on below macros.

Attaching the Read & Write Macros

**vivekhalder** · 11-27-2011, 05:08 AM

Can anyone help me out please ?

**ingfrojas** · 06-08-2012, 07:43 PM

hello
i tried the tow files read and write, i followed the instructions where you reffer shell controls and cddbccontrolroxio, i downloaded CDDBControlRoxio.dll but when i run the macro "Write" popup the next message " error 429 the activex component can´t create the object" how can i pass this error???
thanks

**arlu1201** · 06-09-2012, 06:23 AM

Ingfrojas,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.