Playing an embedded video file.

[styoda]

Hi All,

I've searched on options on how to embed video file into Excel and use this in a VBA userform using Windows Media Player add-on or anything else, but having issues on getting it to work.
So, I?m have a few questions to see if it is possible, hopefully.
I?m using Office365.
I can import the mp4 file into excel as an object, ?Insert? menu => click on ?Object? and then select ?Create from file?. This inserts the mp4 file into excel, but don?t know how to link this object to the Windows Media Player add-in on the VBA userform.
The Windows Media Player add-on has a URL section for the video file, and if the file was stored locally, i.e ?C:\Temp\test.mp4?, this works, but how do I point this to the embedded object/mp4 file?

What I have noticed is the embedded mp4 file is stored in a temporary folder, ?C:\Users\joebloggs\AppData\Local\Temp\? and then in another folder such as ?{6E82E2A2-D55C-4843-AFC3-5D00C2901A29}?, but this folder is different every time the workbook is opened.
Is it possible to find this file location in VBA and then point the Windows Media Player add-in to this location?

Or is there any other way to embed the video file into Excel, it?s only a small video file, less than 1MB.

Hope someone can help,
Thanks

[PrizeGotti]

The Windows Media Player add-on has a URL section for the video file, and if the file was stored locally, i.e ?C:\Temp\test.mp4?, this works, but how do I point this to the embedded object/mp4 file?

You've pretty much answered your question yourself. You don't need to embed the video file in the workbook, as long as you put the file location in the URL section of the control settings, it should work fine.

[styoda]

You've pretty much answered your question yourself. You don't need to embed the video file in the workbook, as long as you put the file location in the URL section of the control settings, it should work fine.

Thanks for your reply, but I require the file to be embedded.

[PrizeGotti]

Then I'm not quite sure what you are trying achieve, because embedding the file, and using the media player control in a userform are 2 separate things, and doesn't require one for the other to function.

[styoda]

Ok, is there a way to embed the file into the workbook and use it in the useform, I'm not aware how to do it?

Thanks

[ByteMarks]

This will extract the embedded file Object1 called VideoPlayBack.mp4 to the folder sPath and load it into the media player.

Please Login or Register  to view this content.

[styoda]

This will extract the embedded file Object1 called VideoPlayBack.mp4 to the folder sPath and load it into the media player.

Please Login or Register  to view this content.

Thank you ByteMarks, this works perfectly.