Looking for the play duration of a mp3 file

[MPW]

I posted this to the Excel Forum last night but I think it might actually belong here... Not sure.

Hey All,

At work we have encountered a strange problem. We have mp3 files that have disk size but no play length. It only happens occasionally but I need a way to test for it.

I am looking for a way to capture the actual file play length for mp3 files.
I would also like file size and size on disk.

The last kicker is I would like a VBA and VBScript version if possible because some of the machines do not have office on them.

Thanks

 

[sous2817]

HAve a look here:

http://spreadsheetpage.com/index.php/file/mp3_file_lister/

not my work, just passing along my google search.

 

[MPW]

Thanks for the link. I think I got what I need.