Thanks for this lesson. Is there a way to make Excel play a short video or to display a small picture at various times of day, or at one certain time every day (assuming the workbook is open)? (Example: At 5:00 PM every day, show a short 10 second video of someone doing a task which needs to be done at that time.) Thanks for any help on it.
@omnipop4936 yes it is possible. I have to create a userform and open it using the timer. In this userform, u have to put a media player as a button (the same way u have buttons, text, etc...). Here is a sample code at form initialization (hopefully it will kick start ur reasearch to make it work): Private Sub UserForm_Initialize() ' Path to the video file Dim videoPath As String videoPath = "C:\Path\To\Your\Video.mp4" ' Change this to your video file path ' Set the URL of the Windows Media Player control Me.WindowsMediaPlayer1.URL = videoPath ' Play the video Me.WindowsMediaPlayer1.Controls.play End Sub
Thank you for taking your time to do this video, but I still have a challenge implementing it. Is there a way I can contact you directly so I explain in details the challenge?
Thanks for this lesson. Is there a way to make Excel play a short video or to display a small picture at various times of day, or at one certain time every day (assuming the workbook is open)? (Example: At 5:00 PM every day, show a short 10 second video of someone doing a task which needs to be done at that time.) Thanks for any help on it.
@omnipop4936 yes it is possible. I have to create a userform and open it using the timer. In this userform, u have to put a media player as a button (the same way u have buttons, text, etc...). Here is a sample code at form initialization (hopefully it will kick start ur reasearch to make it work):
Private Sub UserForm_Initialize()
' Path to the video file
Dim videoPath As String
videoPath = "C:\Path\To\Your\Video.mp4" ' Change this to your video file path
' Set the URL of the Windows Media Player control
Me.WindowsMediaPlayer1.URL = videoPath
' Play the video
Me.WindowsMediaPlayer1.Controls.play
End Sub
Thank you for taking your time to do this video, but I still have a challenge implementing it. Is there a way I can contact you directly so I explain in details the challenge?
Unfortunately, I just teach concepts to be applied on projects. In this case, I advise you to get pro help. Sorry for not being more helpful.
@@EXCELWIZARDINMINUTES Please this is the detailed information of the challenge 👉 ua-cam.com/video/jwxQTSFpZhM/v-deo.html
Thank you.
Welcome Mark! 😊