background music to a spreadsheet?

[penzer]

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

[dominicb]

Good morning penzer

is it possible to have a music file play in the background of the spreadsheet if so how?

Might be. What format is your music in (tip : don't say MP3 )

does it play constantly or will it stop if i perform functions

No idea. There doesn't seem to be a huge demand for musical spreadsheets... Just try it and see I suppose.

HTH

DominicB

[penzer]

mmm ok , well just a music file - i can convert it if need be...

[dominicb]

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

[penzer]

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?

[dominicb]

Hi penzer

can excel be ran in any other program??

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

[penzer]

o ok thanks,, apprantly it is possible to design visual basic code in order to have background music play and as the document opens

[dominicb]

Hi penzer

apprantly it is possible to design visual basic code in order to have background music play and as the document opens

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

[penzer]

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??

[dominicb]

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 :

Please Login or Register  to view this content.

Just run the code PlayMyWAV to kick the whole thing off.

HTH

DominicB

[shg]

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.

[penzer]

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 my spreadsheet is not going to be that good it just has to show as many media variables as possible. (i.t course)