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/
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Posting Permissions
Reply With Quote
