How to play MP3 Files From Excel


On the off chance that you make a hyperlink in a cell that focuses to a MP3 record, tapping the hyperlink plays the sound document in your default MP3 program. Be that as it may, there’s a major issue: You will get no less than one (presumably two) irritating security messages. Microsoft has depicted an approach to cripple these messages, however it’s a confounded method.

Get ms office 365 now:

Here’s an elective approach that uses a straightforward VBA large scale. The large scale expect the dynamic cell contains a contend filepec for a MP3 record (that is, the full way and the filename).

Sub PlayMP3()

Application.ScreenUpdating = False

On Error Resume Next

ActiveSheet.OLEObjects.Add(Filename:=ActiveCell.Text, Link:=True).Select

In the event that Err.Number <> 0 Then

Application.ScreenUpdating = True

MsgBox “Couldn’t play ” and ActiveCell.Text

Leave Sub

End If



End Sub

The PlayMP3 method makes an OLE question that connects to the document in the dynamic cell. The Verb technique stacks the connected document into the default MP3 player, and after that the OLE question is erased. In the event that the dynamic cell contains an option that is other than a legitimate way to a MP3 record, a message is shown and nothing happens. It’s quick, and you’ll never observe a security cautioning message.

Visit here:

Leave a Reply

Your email address will not be published. Required fields are marked *