Printable View
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
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/
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/