ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Audio Files Metadata (https://www.excelbanter.com/excel-programming/369530-audio-files-metadata.html)

Pflugs

Audio Files Metadata
 
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

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

Steve



"Pflugs" wrote in message
...
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




Pflugs

Audio Files Metadata
 
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

"Steve Yandl" wrote:

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

Steve



"Pflugs" wrote in message
...
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






All times are GMT +1. The time now is 05:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com