Linking to a SharePoint Video

In my Excel file I want to create a pop-up window that plays a specific video in a pop-up form when a command button is clicked. My code works great when the URL is set to a file on my computer. (So I know I'm headed down the right path.) My problem is when I try to play a video that is on our SharePoint site. I get the pop-up, but nothing plays. Even when I click the play button on the control.

First here is the working code that runs on the form's Initialize event;

Please Login or Register  to view this content.

When I change it to this, it doesn't work. I'm thinking I need to do something with the URL, such as change the format of the SharePoint link so it's just looking at the file and nothing else, but I have been unable to find what to do exactly.

Please Login or Register  to view this content.

*Because I am new to the forums it won't allow me to add even fictitious links in my post. In my code I have the normal "https stuff" then "MySite.sharepoint" which ends with a .com. 

Thanks for your help.

Think through this I'm guessing I need to create an object to serve as a connection to our SharePoint site, but I have no idea what that would look like. Any suggestions?