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 03: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 10: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 10:14 PM

Mate that worked perfectly, thanks for that.

Cheers,

Mattio.

mattio 25th September 2017 12:26 AM

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 09:40 AM.

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