vba to play mp3 file

[dgillz]

Can anyone help with this? I would like vba to play a specified mp3 file. Code:

Private Sub Playfile
playfile ("c:\myfile.mp3")
End sub

Obviously the above is not working, and I know I need to create a function called playfile, but I have little idea how to start. Does anyone know how to do this?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[jedraw]

If you have a default mp3 player (In my case it was QuickTime), you can get the mp3 to play in an IE browser window using the following

Sub testMP3IE()
dim MusicPath as string
MusicPath = "I:/MyMusic/Ray Charles/Ray!/09 - Georgia On My Mind.mp3"
Application.FollowHyperlink MusicPath
End Sub

 

[fumei]

FollowHyperlink, for me, opens the MP3 in Windows Media Player.


unknown