How to initiate a sound via VBA?

[Hartmut \(Harry\) Kloppert]

At a certain event (push button) I would like to have
a sound (.wav) file being played.
Any advise?

(for a test, I reconfigured the "Default Beep" in Windows
to the desired wav-ile. And then programm a simple
"Beep" in VBA. But that (of course) gives me a lot
of strange sounds at many other windows-events...)

Hary

 

[Mike H]

Hi,

You can find out how here

http://www.j-walk.com/ss/excel/tips/tip59.htm

Mike

 

[Hartmut \(Harry\) Kloppert]

Thanks, Steve. That was easy and effective!

Harry