Play sound file at set time each day

Welcome to the forum!

You can set your xls to play the sound file in the Open event. In Windows Scheduled Events, add a BAT filename that contains the path to your xls.

I wish a macro to compare present time with a scheduled time, and if equal, to play a wav file at that time as a reminder then a dialogue box to add results of that event please, not just on opening, but during the day too.

You said you wanted it done at 5 AM. The method that I gave does that for you.

Was there some other criterion? If so I would need to know.

If you don't want to use Windows Scheduler, then you would need to leave the Excel file open and use the OnTime method.

Hopefully, T would have 5 different times in the same day to be alerted to by playing different music. I have a simple contional test that returns "true" when the scheduled time arrives, but I have to hit F9 to get the sheet to recalculate. How can the spreadsheet tick over as time passes then set off the conditional test which then activates the playing of the souns please?

What does this relate to and how can I use it?

You will either have to launch the Excel file at a certain time (Use Windows scheduler, similar to what Kenneth Hobson said), or leave the file open with an 'Ontime Method' (again, as Kenneth Hobson said). Once you decide which path you want to travel, that will decide the code behind that we can guide you on. ~G

Originally Posted by thetaplus

At 5am each day I want a "Motivation.wav" music file to open and play and a form appear where I enter in the number of sit ups, push-ups I get done,

I can't offer much advice regarding your Excel question but I would have to say that you are the most driven person I have ever met. :-)

Hello !

I wish to leave it open, have the music activate a different scheduled times, then pull up a form so I can enter in the results of that particular activity please

Regards

so far i have this which works to play the music file


['This function declaration must be entered onto a single line.
Declare Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" _
(ByVal lpszSoundName As String, ByVal uFlags As Long) As Long

Sub PlaySound1()
If Application.CanPlaySounds Then
'Substitute the path and filename of the sound you want to play
Call sndPlaySound32("C:\Documents and Settings\Ishman\My Documents\excel\Music for Excel\MissionPossible.wav", 0)
End If
End Sub]

Do I put in something like this please?

Application.OnTime TimeValue("13:07:00"), "PlaySound1"

Sort of like a New Year's Resolution - have the spreadsheet remind me audibly what I should be doing to get my life on course!

so far i have this which works to play the music file


['This function declaration must be entered onto a single line.
Declare Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" _
(ByVal lpszSoundName As String, ByVal uFlags As Long) As Long

Sub PlaySound1()
If Application.CanPlaySounds Then
'Substitute the path and filename of the sound you want to play
Call sndPlaySound32("C:\Documents and Settings\Ishman\My Documents\excel\Music for Excel\MissionPossible.wav", 0)
End If
End Sub]

Do I put in something like this please?

Application.OnTime TimeValue("13:07:00"), "PlaySound1"
Edit/Delete Message