ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   PLAYING A SONG LIST FROM EXCEL WORKSHEET (https://www.excelbanter.com/excel-discussion-misc-queries/207669-playing-song-list-excel-worksheet.html)

Miryogi

PLAYING A SONG LIST FROM EXCEL WORKSHEET
 
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

PLAYING A SONG LIST FROM EXCEL WORKSHEET
 
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.


"Miryogi" wrote:

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


Mike Middleton

PLAYING A SONG LIST FROM EXCEL WORKSHEET
 
JLatham -

a better way of doing it <


iTunes?

- Mike


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
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.


"Miryogi" wrote:

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

PLAYING A SONG LIST FROM EXCEL WORKSHEET
 
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.

"Mike Middleton" wrote:

JLatham -

a better way of doing it <


iTunes?

- Mike


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
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.


"Miryogi" wrote:

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






All times are GMT +1. The time now is 04:26 PM.

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