LinkBack URL
About LinkBacks
is it possible to have a music file play in the background of the spreadsheet if so how? and then if it is possible does it play constantly or will it stop if i perform functions on the spreadsheet or move sheets..
thanks is advance
is it possible to have a music file play in the background of the spreadsheet if so how? and then if it is possible does it play constantly or will it stop if i perform functions on the spreadsheet or move sheets..
thanks is advance
Good morning penzer
Might be. What format is your music in (tip : don't say MP3Originally Posted by penzer
)
No idea. There doesn't seem to be a huge demand for musical spreadsheets...Just try it and see I suppose.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
mmm ok , well just a music file - i can convert it if need be...
Hi penzer
Yes, but is your source file a .wav file or a midi file? Excel will play either of those, but the same code (you have to use a macro utilising APIs - it's not a native Excel thing) will not do both. If it's an mp3 file, I'm not sure whether it can be done, so it would need converting.
DominicB
o ok,, im going to leave it i think sound complicated for my noob like brain. can excel be ran in any other program?? like a functioning spreadsheet working on another application, if so wot program?
Hi penzer
Not if you want to maintain full functionality. You can save any workbook as a HTML file, so it will open under Explorer (or any other browser), but all your functionality within formulae and such will be lost.
HTH
DominicB
o ok thanks,, apprantly it is possible to design visual basic code in order to have background music play and as the document opens
Hi penzer
It is possible, as I said earlier, but before I can give you the code to do that, I need to know what format your music is in. Is it a .wav file, midi file...?
DominicB
o sorry, i was being clueless.. mm the music will be just an mp3 file. (sorry no idea about terms - just a standard music file) hope that is the correct answer??
Hi penzer
OK, so you're trying to play an MP3 file from within Excel - this is particularly difficult. I've never actually tried it myself, and might have a go next week when I have some time, but you might like to have a look at these two threads that give some instruction on how to do it :
http://www.mrexcel.com/forum/showthread.php?t=293213
http://www.mrexcel.com/forum/showthread.php?t=167671
...but be warned it is heavy going.
However, if you can convert your tracks to .wav (search Google for a free tool) then the task becomes much easier - use this code :
Just run the code PlayMyWAV to kick the whole thing off.
Please Login or Register to view this content.
HTH
DominicB
If I wanted to listen to music while using Excel, I'd use an MP3 player.
If I wanted to dazzle other people by playing music when they opened one of my spreadsheets, I would first make sure that the spreadsheet itself was so awe-inspiring in its appearance, so startling in its clarity, so intuitive in its use, so amazing in its utility, so ... ... ... that it lacked only a symphony to make it a completely transcendental experience. And since my next spreadsheet that has all those attributes will also be my first, it might be some time before I do. Just a thought ...
In the meantime, you could do Tools > Options > General, and check Provide feedback with sound.
sorry i dont really understand what point you are marking but cheers for that tip iil give it a go , also thanks for the script ,, iil try and convert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks