LinkBack URL
About LinkBacks
o ok thanks,, apprantly it is possible to design visual basic code in order to have background music play and as the document opens
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...?Originally Posted by penzer
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
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.
Private Declare Function PlaySound Lib "winmm.dll" Alias "PlaySoundA" (ByVal lpszName As String, ByVal hModule As Long, ByVal dwFlags As Long) As Long Const SND_SYNC = &H0 Const SND_ASYNC = &H1 Const SND_FILENAME = &H20000 Sub PlayMyWAV() Call PlaySound("C:/MyWavFile.wav", 0&, SND_ASYNC Or SND_FILENAME) End Sub
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 convertmy spreadsheet is not going to be that good it just has to show as many media variables as possible. (i.t course)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks