Play WAV file

[john]

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

 

[Corentin Cras-Méneur]

Hi John,

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 are plenty of apps that can play WAV on MacOS X. You can try
searching for WAV on http://www.versiontracker.com/

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.

WAV is not really one of the core formats of QuickTIme ;-) That's the
base of your problem since Office relies on QT for audio/video playback.

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

Convert them to a format QuickTime supports natively...

Corentin

 

[Jim Gordon MVP]

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()
ActiveSheet.Shapes("Picture 1").Select
Application.CommandBars("Movie").Controls(2).Execute
End Sub

-Jim