Tuesday, August 12, 2008

Play Audio File using Excel VBA

Play Audio File using Excel VBA / Excel VBA Play Wav File

Here is a small snippet used by Pradeep Meesala to play a wav file. He has used this for an elegant splash screen, which was a nice combination of music and display

The code uses PlaySound API Function

Private Declare Function PlaySound Lib "winmm.dll" _

Alias "PlaySoundA" (ByVal lpszName As String, _

ByVal hModule As Long, ByVal dwFlags As Long) As Long

Sub Play_Wav_File()

Dim sWAVFile As String

On Error GoTo Err_Play

sWAVFile = "C:\Temp\Windows XP Logon Sound.wav"

PlaySound(sWAVFile, &O0, 0)

Err_Play:

If Err <> 0 Then

Err.Clear()

End If

End Sub

5 comments:

  1. Anonymous1:05 PM

    I get a compile error at this code snipet . It says only comments may appear after End Sub, End Function, or End Property ??? Help

    Private Declare Function PlaySound Lib "winmm.dll" _
    Alias "PlaySoundA" (ByVal lpszName As String, _
    ByVal hModule As Long, ByVal dwFlags As Long) As Long

    ReplyDelete
  2. Anonymous1:08 PM

    I get compile error when I try this on Excel 2007

    ReplyDelete
  3. I believe it should be inserted at the start of a module after any option statements but before any procedures

    ReplyDelete
  4. Anonymous9:48 AM

    Doesn't work for me no matter what I do.

    ReplyDelete
  5. Anonymous7:05 PM

    I've been using for years and have had no issues. you need to insert it before you start a sub

    ReplyDelete

StumbleUpon
Share on Facebook
Related Posts Plugin for WordPress, Blogger...
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.