Â
Hi, I need an immediate help. Is there any special software with audible reminders excel? If you have please send the download link. And send some helping tutorial explanations for how to use that software, Special features, Main advantages and disadvantages.
Hi Allison,
I hope I can help you on these. You can play sound from excel file when any desired condition you have set have met. I am giving you an code snippet that will help you to get that desired behavior and the sound will be played by windows media player.
Here you go –
Dim excelSound
excelSound = Shell("C:Program FilesWindows Media Playerwmplayer.exe
c:sound.wav", vbHide)
I have taken into consideration that you have sound.wav file into C drive.
Thanks.
Hi AlisonPFleckenstein,
How are you? I can help you to give some information as audible reminders in excel, you can take an user defined Function.
Put this in a code module.
Private Declare Function PlaySound Lib "winmm.dll" Alias "PlaySoundA" (ByValÂ
lpszName As String, ByVal hModule As Long, ByVal dwFlags As Long) As Long
Public Function PlayWavFileIF(WavFile As String, Condition As Boolean) AsÂ
Boolean
Const SND_ASYNC = &H1, SND_FILENAME = &H20000
If Condition Then PlaySound WavFile, 0, SND_ASYNC Or SND_FILENAME
PlayWavFileIF = Condition
End Function
You may take other help from this forum:
http://softwaretopic.informer.com/audible-reminders-excel/
https://www.pcreview.co.uk/threads/audible-alarm-macros.997547/
