PDA

View Full Version : Accessing File Properties in an audio file



new2V
09-09-2018, 01:11 AM
Hi all,

I am new to VBA and I am currently writing a macro to get the file name of the files inside a folder. However, I would like to change the title of the files too but I do not know how to access the title property. The "Title" property I would like to edit manually would be done so by right clicking a file, and click properties. Go to details and change the title of the MP3 file. Is there anyway to do so?

Regards,
Jack

Kenneth Hobs
09-11-2018, 07:33 AM
Welcome to the forum!

Reading file property values is easy. Writing to them is not.

The only way that I have written to file properties was to use dsofile.dll. It is 32bit so it won't work for 64bit. If interested see: http://www.cpearson.com/excel/docprop.aspx

The other 3rd party method would be to use a command line driven application like ExifTool.exe. It is a huge file. Do it manually and then post your command line string back here if you need help automating it in VBA. https://www.sno.phy.queensu.ca/~phil/exiftool/

Paul_Hossler
09-11-2018, 08:45 AM
Instead of trying to make VBA do it, why not use a program designed for such things?


This is a terrific program (small donation requested) which has a special purpose 'macro' language called 'Actions' that can do almost anything

https://www.mp3tag.de/en/