Answered to soon...
Playing an MP3 without showing Mediaplayer seems not too hard.

Private Declare Function ShellExecute Lib "shell32.dll" Alias _
"ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal _
lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String,
_
ByVal nShowCmd As Long) As Long

Private Sub wsBtnMP3_Click()

ShellExecute vbNull, "Open", "C:\a.mp3", vbNullString, "C:\", 0

End Sub




"moon" schreef in bericht
. ..

Studying a language and excersising alphabet pronunciation..?
I don't think VBA can do this without using a self-made or downloaded
ActiveX control.





"Maxi" schreef in bericht
oups.com...
I have few .mp3 files in C:\MP3 folder
a.mp3
b.mp3
c.mp3
.
.
.
z.mp3

These files are of duration 10 seconds

In an excel file, I want a text box that should allow two characters.

The moment I open the excel file, it should take the cursor in that
textbox automatically.

If I type "A" in the textbox, it should play a.mp3 file without opening
the mp3 player. (I am using musicmatch/windows media player mp3 player)

If I type "B" as the second character in the textbox, it should erase
"A" which was entered earlier, show the character "B" in the text box
and play b.mp3 file.

If b.mp3 is playing and before the song is over (before 10 seconds) if
I enter C as the second character in the textbox, it should stop b.mp3
song and start plaing c.mp3

If I type any other character or if I press any other key besides A-Z,
it should stop the current song and should not play anything, it should
just erase value in the text box and place the cursor there and wait
for an A-Z input.