Cmd Button Code to Display Video in Windows Media Player Object in Spreadsheet

Hi All,

I have a sample spreadsheet (uploaded to this thread) in which I have 10 command buttons named 'Video 1' to 'Video 10'. Next to these buttons is a Windows Media Player Object.
I require the code that upon clicking any of the video command buttons, the relevant video is opened and shown in the windows media object within the same sheet (sheet1).

I'm sure the code for each button will be the same apart from the cmd button reference number/name and the link to the file to be played.

If we assume all the videos are called as per their buttons i.e. Video 1.wmv, Video 2.wmv ... Video 10.wmv; and the location of these files is under 'C:\Films', can someone post up some code for button 'Video 1' making it clear which variables to change for linking to the different files.

Thanks in advance - I'm sure this is no doubt very simple for you guys!

Cheers!

Code in a standard code module

Please Login or Register  to view this content.

You can assign the same macro to all buttons.

This code doesn't require the object, it calls up MediaPlayer

In a Standard module

Please Login or Register  to view this content.

In the sheet module

Please Login or Register  to view this content.