I want to make a sound alert. But It not use the external speaker (Bee
function can do this).
Is there anyone know any Macro function in Excel can do this?
Thank you

+----------------------------------------------------------------
| Attachment filename: jig.gif
|Download attachment: http://www.excelforum.com/attachment.php?postid=378485
+----------------------------------------------------------------

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

Hi bookworm98,

As far as I know, VBA has only BEEP sound.


--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)

URL:http://www.interq.or.jp/sun/puremis/...astersLink.htm


/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


"bookworm98" wrote in message
...

I want to make a sound alert. But It not use the external speaker (Beep
function can do this).
Is there anyone know any Macro function in Excel can do this?
Thank you!


+----------------------------------------------------------------+
| Attachment filename: jig.gif |
|Download attachment:
http://www.excelforum.com/attachment.php?postid=378485|
+----------------------------------------------------------------+

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

You can do something like:
Private Sub PlaymySound()
Call PlaySound("c:\whatever.wav", 0&, SND_ASYNC Or SND_FILENAME)
End Sub

see
http://support.microsoft.com/default...NoWebContent=1
for more info

HTH
Phil


"bookworm98" wrote in message
...

I want to make a sound alert. But It not use the external speaker (Beep
function can do this).
Is there anyone know any Macro function in Excel can do this?
Thank you!


+----------------------------------------------------------------+
| Attachment filename: jig.gif |
|Download attachment:
http://www.excelforum.com/attachment.php?postid=378485|
+----------------------------------------------------------------+

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

Hi Phillips,

I believe wav file needs external speaker...what I wrote may wide of the
mark.


--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)

URL:http://www.interq.or.jp/sun/puremis/...astersLink.htm


/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


"bookworm98" wrote in message
...

I want to make a sound alert. But It not use the external speaker (Beep
function can do this).
Is there anyone know any Macro function in Excel can do this?
Thank you!


+----------------------------------------------------------------+
| Attachment filename: jig.gif |
|Download attachment:
http://www.excelforum.com/attachment.php?postid=378485|
+----------------------------------------------------------------+

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

Thanks all a ton. NotwithStanding all your answers didn't solve my
problem. But I found it my way. Anyway thanks


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

Thanks all a ton. NotwithStanding all your answers didn't solve my
problem. But I found it my way. Anyway thanks


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