playing sound of the team what is needed to play in the next round

[siebrenbeens]

good evening,

i have a excelfile with a complete competition of a volleybal tournament. what i am looking for is a code that calls out specific sound files (team names spoken) when a specific team needs to play in the next round of the tournament

i hope some1 can help me out.

best regards,

siebren beens

 

[mrshl9898]

As far as I know you'd need to insert the sound files as objects Insert>Object.

Then use a line like this to play the file (this is from a recorded macro):

Sub [COLOR=#333333]Playsound1()[/COLOR]
ActiveSheet.Shapes.Range(Array("Object 1")).Select
Selection.Verb Verb:=xlPrimary
End Sub

If you want it to run at certain times:

[COLOR=#333333]Application.OnTime TimeValue("15:00:00"), "Playsound1"[/COLOR]

 

[siebrenbeens]

this is not what i'm looking for, but thanks anyway.

do you need more info?

 

[mrshl9898]

Do you have the sound files attached to the sheet?

How do you currently get them to play?

Do they need to play at fixed times?

 

[siebrenbeens]

if i have the code i am going to create soundfiles corresponding to the teamnames.

currently we are using a microphone.

and yes, the matches have a constant interval of 12 minutes.

if you want i can attach the file i am working with.

 

[siebrenbeens]

ah, i cant attach a file

 

[mole999]

Some ideas here > https://www.mrexcel.com/forum/excel-questions/937480-play-embedded-wav-file-when-workbook-opens-but-without-showing-media-player.html?highlight=star+trek

excel also has SPEAK function in VBA

 

[siebrenbeens]

@ mole999 yeah i have seen that function, but that won't be an option, because itare dutch teamnames, so it would sound like ****

 

[siebrenbeens]

https://www.dropbox.com/s/n2cfp1vte1u6nn5/Grastoernooi 2016 invulmacro 1.1.xlsm?dl=0

this is the file i am working with. maybe it helps

 

[siebrenbeens]

there are preset times when the match starts. so is it possible to compare system time with the preset matchtime. and then call the soundfiles corresponding with the teamnames 2 minutes before the start of the match