Thread: mediaplayer
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default mediaplayer

I have done some of this.
Post your code.

The sub below will play, with whatever your default is, the file when typed
as shown below
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
ActiveWorkbook.FollowHyperlink Address:= _
"C:\A_D\" & ActiveCell & ".mp3"
End Sub
If typed liked this the sub will play the song automatically.
Ahmad Jamal - Poinciana


--
Don Guillett
SalesAid Software
Granite Shoals, TX

"DeeJee" wrote in message
. be...
I start mediaplayer (from excel) with shell as vbMinimizedNoFocus, and

with
the file to play in a string value.
But however mediaplayer is minimized, the button on the taskbar always

keeps
the focus,
and I have to click my worksheet to activate it.
Or a click on the mediaplayer button on the taskbar gives the focus back

to
my worksheet to.
ActiveWorkbook.Activate or ActiveWorkbook.Sheets("Blad1").Activate is no
solution.
How can I bring back the focus to my worksheet in my code?