OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   General Topics (http://forums.ozmium.com.au/forumdisplay.php?f=59)
-   -   Open MP4 File With Macro (http://forums.ozmium.com.au/showthread.php?t=31613)

mattio 24th September 2017 02:47 PM

Open MP4 File With Macro
 
Hi guys,

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

Cheers,

Mattio.

walkermac 24th September 2017 09:05 PM

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

mattio 24th September 2017 09:14 PM

Mate that worked perfectly, thanks for that.

Cheers,

Mattio.

mattio 24th September 2017 11:26 PM

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.


All times are GMT +10. The time now is 07:41 PM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.