Get video time from simple URL

[gach]

Hi,

I've been wondering if it will be possible to build some kind of macro to read the length of video just by a simple URL like this: https://demo.askia.com/WebProd/Resou...gbuckbunny.mp4

Let's suppose that I have column A with videos URL's and I want to get the time of each video on the same row (column B) with that time format (00:30 mm:ss).

[Haluk]

You can only get the file size of the video in bytes from the URL that you have given.

The below VBA code will give you the file size only...

Edit: Because of an interesting restriction of the forum, I couldn't write the full URL in the code below. You have to supply the related missing part at the beginning of the URL

Please Login or Register  to view this content.

In order to estimate the duration of the video you need to know some other info as well..... such as; Frame Width, Frame Height, Frame Rate etc.


.

[Haluk]

But; if you have the video file on your computer, then you can access the file properties and get the required value.

The below code will do this for the file C:\TestFolder\bigbuckbunny.mp4

Please Login or Register  to view this content.

.