PLAYING A SONG LIST FROM EXCEL WORKSHEET

[Miryogi]

Please help!
I have a songs list in an Excel worksheet.
Each line other song.
Now I'm looking for a solution to play the songs one after unother without
any new command for each song.
Thanks in advance for your help

 

[JLatham]

What type of files are listed? .wav? .mp3? .mid? or some other type?

I can give you some code that will play these, but in all cases, we have to
know the full path to the file (it has to be part of the entry in the songs
list on the sheet).

Also, the code I have for the playing of .mp3 files is rather rough and
unforgiving - once you start playing the list, it's damned near impossible to
stop it until the last song plays! I'm looking at the command used to see if
there isn't a better way of doing it than I am at the moment.

 

[Mike Middleton]

JLatham -

a better way of doing it <

iTunes?

- Mike

 

[JLatham]

Actually, I was thinking just about anything with a 'playlist' feature - be
it iTunes, Media Center or whatever. The code I have now was set up just to
play a single cut, and while I've got it modified to play through a list now,
because it goes into "wait" state, it pretty well locks up that copy of Excel
until the list is played. I've got to bone up on the mciSendMessage() API to
find how to simply test to see if it's ready to play another cut rather than
going into wait-state before executing the next iteration of the loop.