Need help with formula to retrieve a video length
Hello,
I have a running list in excel that I use to track quicktime (.mov) videos and their lengths. The file size is not always related to the actual video length due to different compression values. Is there a way that one can use a formula to pull the video length into excel by matching the file location and the file name? I have been entering them in manually but need to find a way to import the data automatically. Any and all help is greatly appreciated.
j-walk has already done this for you and made it ready available.
Check the below link
http://j-walk.com/ss/excel/tips/tip103.htm
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks Sixthsense.
The file that J-Walk created, when run, generates the following error:
Run-time error '445':
Object doesn't support this action.
Could it be that the macro is only written to work on MP3 files? The files that I am looking to import the data are .mov files.
I have not tested that J-Walk exe file.
Check this link for excel vba solution...
https://groups.google.com/forum/#!to...os/XVretMRV7uc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks