calculate time

[rvik]

hi,

i have about 5000 wav files in a directory. i want the file length i
minutes of each file copied to an excel sheet which already contain
the file names in a column..

 

[Don Guillett]

I have never heard of a way to calculate that from a file name. Length,
yes - Time of play NO??
Cells(i + lastrow, 3).Value = FileLen(.FoundFiles(i))
unless there is a way from knowing the filelen

 

[David McRitchie]

Probably it is part of the file structure. The easiest way
would probably be to read a directory that shows such information.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I have never heard of a way to calculate that from a file name. Length,
yes - Time of play NO??
Cells(i + lastrow, 3).Value = FileLen(.FoundFiles(i))
unless there is a way from knowing the filelen