Excel sound 1

[RobBroekhuis]

What's the cleanest way to play sounds from Excel VBA? What I've done so far is insert an object from file, browsed for the .wav, then formatted the object to 100% brightness (white) and no line border, and made it small enough to fit inside cell borders, so it's invisible. I named it "Chime", and put the following code in my VBA macro:

ActiveSheet.Shapes("Chime&quot.Select
Selection.Verb

It works, but I can't help but feel there should be a less circuitous way to do this.
Rob

 

[Nikita6003]

Hi Rob

dunno if this is of any use but I've used this example by Ole Erlandsen for some time now. Works ok & seems less cirquitous (that's a genius kinda word ... ;-))

http://www.erlandsendata.no/english/vba/sound/playnotes.htm

Cheers
Nikki

 

[RobBroekhuis]

Thanks Nikki,
The dll call was really all I needed. I still don't think I can actually implement it, because I don't want to distribute a .wav file with the workbook, and this approach requires a file external to the workbook. But I'm definitely keeping the dll reference in my personal.xls!
Rob