Hello experts,

I would like to ask if there is a way to get the duration/length of video files (mine is mp4 file only) through vba code. The mp4's are located in one folder. A simple excel list will do for me (example below).

Filename Length
9001.mp4 00:28:36
9002.mp4 00:18:03
9003.mp4 00:20:09
9004.mp4 00:24:14

Any help will be very much appreciated. Thanks in advance.