Excel Sound Alert (2002/2003)

[Robert Hall]

I would like to play a sound alert (standard wav file) when a particular condition is met in a spreadsheet cell. Specifically, I have live stock quotes coming into a spreadsheet through DDE and would like to play a sound alert when a particular value or condition is met. That trigger value or condition would be placed in another cell. I have programmed a few Excel macros, though am no expert on macros by any means, but I cannot find any command to play a sound. Could somebody please explain how I could do this?

Thanks and regards,
Rob

[HansV]

If you want to sound the system beep, you can simply use
<code>
Beep
</code>
To play a .wav file, place the following declarations at the top of a module:
<code>
Private Const SND_ASYNC = &H1 ' play asynchronously
Private Const SND_FILENAME = &H20000 ' name is a file name

Private Declare Function PlaySound Lib "winmm.dll" Alias "PlaySoundA" _
(ByVal lpszName As String, ByVal hModule As Long, ByVal dwFlags As Long) As Long
</code>
You can then use an instruction such as the following to play a sound in your code:
<code>
PlaySound "C:WindowsMediaTada.wav", 0, SND_FILENAME Or SND_ASYNC</code>

[Robert Hall]

Thanks very much Hans. I will give this a try tomorrow.

Regards
Rob