Audio Files Metadata

[Guest]

I would like to write some macros that can read or write to a file's metadata
(ie. track number, track title, album artist, etc.) Could someone tell me
what reference I should add or how to go about getting that information? Can
it even be accessed using Excel VBA?

Thanks,
Pflugs

 

[Steve Yandl]

For reading the metadata, take a look at this example from John Walkenbach
http://www.j-walk.com/ss/excel/tips/tip103.htm

Steve

 

[Guest]

Thanks for the link.

I was able to modify this to work. I've never had good luck with
..FileSearch, which his code employs, but I was able to retrieve the file
properties.

However, I want to take it further than that. I want to programmatically
set those extended properties. I can't seem to find this anywhere, and I
haven't found a third-party software package to fit my needs. I'd like to
just make my own and customize it, but I can't set those values.

Can someone tell us how to SET extended property values using VBA?

Thanks,
Pflugs