Widows Media Player

D.S.Rama Rao · 02-07-2012, 09:52 AM

I Have Embedded Windows Media Player In An EXcel Sheet Through Developer,Insert,Active Controls Tabs

However I am not able to activate the same.

Can any body help

Regards

D S Rama Rao

**royUK** · 02-07-2012, 10:53 AM

You need to use VBA

D.S.Rama Rao · 02-09-2012, 03:55 AM

Dear Sir,

CAn you help me in developing VB Code

Regards

D S Rama Rao

**Jack in the UK** · 02-09-2012, 01:46 PM

try this..

Option Explicit

Public Sub Assign_WMP()
   
    Sheet1.WindowsMediaPlayer1.URL = “C: myFile.wma”

    Do While Sheet1.WindowsMediaPlayer1.openState <> 13
       DoEvents
    Loop

    Sheet1.WindowsMediaPlayer1.Controls.Play

End Sub
 
Public Sub Play()
    Sheet1.WindowsMediaPlayer1.Controls.Play
End Sub

D.S.Rama Rao · 02-10-2012, 04:02 AM

Thanks for the help.However with the code furnished by you Windows media Player is activated.Now help me in making it play the song i want.

Regards

D S Rama Rao

D.S.Rama Rao · 03-04-2012, 07:28 AM

I have solved the problem my self

thanks

D s Rama Rao

**royUK** · 03-04-2012, 10:59 AM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save