ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   mediaplayer (https://www.excelbanter.com/excel-programming/273256-re-mediaplayer.html)

Don Guillett[_4_]

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?








All times are GMT +1. The time now is 01:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com