G'day,
The following code changes the title of an open workbook to abc:
However, this BuiltinDocumentProperties is limited to MS office files. Just wondering if it is possible to extract & change the metadata of MP3 files through VBA. Have anyone come across or developed a script to do so in VBA? Specifically, I'm after a code to change the title from "Track xx" to the actual name of the mp3 file itself.ActiveWorkbook.BuiltinDocumentProperties(1) = "abc"
The title info of a file can be manually accessed & modified by right clicking on the file name inside windows explorer then "properties" - "summary tab". It would be too cumbersome for to modify some 90 odd mp3 files. I've done some googling but couldn't find anything.
Thanks in advance for sharing.
Regards
kp