Special software with audible reminders excel

Asked By 0 points N/A Posted on -
qa-featured

 

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.

SHARE
Best Answer by John L Krug
Answered By 60 points N/A #170857

Special software with audible reminders excel

qa-featured

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.

Best Answer
Best Answer
Answered By 10 points N/A #170858

Special software with audible reminders excel

qa-featured

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/

http://www.pcreview.co.uk/forums/audible-alarm-macros-t997547.html

http://office.microsoft.com/en-us/outlook-help/turn-sound-effects-on-or-off-HP010080732.aspx

Login/Register to Answer

Related Questions