Special software with audible reminders excel

Asked By AlisonPFleckenstein 0 points N/A Posted on - 03/20/2013

 

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.

• Status: Open
• Question Views: 696
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Development Software

Best Answer by John L Krug

Go To Solution

Answered By Jose K Vincent 60 points N/A #170857

Special software with audible reminders excel

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.

About Jose K Vincent

Questions
109

Answers
101

Best Answers
28

• Vote Up 0 Vote Down

• Posted on - 04/06/2013
• Question Category: Development Software

Best Answer

Best Answer

Answered By John L Krug 10 points N/A #170858

Special software with audible reminders excel

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/

https://support.office.com/en-us/article/Turn-sound-effects-on-or-off-in-Outlook-e37d6cb4-5313-4d60-87fd-c4a7c2e4df59?CorrelationId=723912a1-80a8-45f2-866a-1684f8cd0c95&ui=en-US&rs=en-US&ad=US&ocmsassetID=HP010080732

About John L Krug

Questions
24

Answers
100

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 04/07/2013
• Question Category: Development Software