Re: Play WAV file

Hi John,

As you probably noticed the wav file looks like a picture to visual basic.

You can select the desired picture then use vba to activate the Play button on the Movie toolbar

Sub PlayWav()
    Active***.Shapes("Picture 1").Select
    Application.CommandBars("Movie").Controls(2).Execute
End Sub

-Jim

--
Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>


john@xxxxxxxx wrote: 
Does anyone have any ideas how I can play a WAV file on a Mac.  I am
running Mac Excel 5.2.  All of the VBA examples I have found on the web
are for running Wav files under Windows.

There should be a way, but VBA is much less user-friendly on a Mac.  I
can insert the WAV file as a "movie" and it had a toolbar with a Play
button.  I can get the WAV file to play manually and tried to record a
macro, but no luck.

If I can't play a WAV file, does anyone know how to generate
interesting beeps?

Thanks in advance for any thoughts?
JDF

.

Loading