You can use a Windows API function to play a WAV file. E.g.,

Declare Function sndPlaySound32 Lib "winmm.dll" Alias _
"sndPlaySoundA" (ByVal lpszSoundName As String, _
ByVal uFlags As Long) As Long

Sub PlaySound(FileName As String)
sndPlaySound32 FileName, 0
End Sub

Call this procedure with code like

PlaySound "C:\MyWavFile.wav"



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Full Monty " wrote
in message ...
Running Excel 97:

Currently using a Countdown (shown in the Excel tips) from 180
to 0 in
th status bar as a timer.

Would like Excel to automatically play a corresponding WAV file
once
the countdown reaches certain intervals. (30, 10, 0)

Each of the three intervals listed would have their own WAV
file.

I am just learning VBA and this site has been very helpful thus
far.
But I am stuck at this point and don't know how to proceed.

Thanks for the help!


---
Message posted from http://www.ExcelForum.com/