Open MP4 File With Macro

[mattio]

Hi guys,

Anyone know how to write a macro to open a video file in Exel?

Cheers,

Mattio.

[walkermac]

Public Sub trythisout()
ThisWorkbook.FollowHyperlink "C:\path\videofile.mp4"
End SubOr use a URL, if the file is on the web

[mattio]

Mate that worked perfectly, thanks for that.

Cheers,

Mattio.

[mattio]

Is it possible to link to a dynamic code? The file I want to open is a race replay on an external drive and the hyperlink will be dynamic. I have a cell with the dynamic hyperlink that works but I can't link it to a button.

Cheers.