Digita
02-11-2008, 09:14 PM
G'day,
The following code changes the title of an open workbook to abc:
ActiveWorkbook.BuiltinDocumentProperties(1) = "abc"
However, this BuiltinDocumentProperties is limited to MS office files. :banghead: 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.
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
The following code changes the title of an open workbook to abc:
ActiveWorkbook.BuiltinDocumentProperties(1) = "abc"
However, this BuiltinDocumentProperties is limited to MS office files. :banghead: 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.
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