| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sounds in Excel
Is there any way to get excel to play wav sounds on events?
I noticed that the standard VB functions for sounds are not available in the VBA help section, was just wondering if you could call a windows api to do it or something. Thanks, -Joel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sounds in Excel
Joel,
Yes, you can use an API call to play a wav file. See http://www.cpearson.com/excel/excelM.htm#PlayWAV for details. -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "J. Vandenberg" wrote in message om... Is there any way to get excel to play wav sounds on events? I noticed that the standard VB functions for sounds are not available in the VBA help section, was just wondering if you could call a windows api to do it or something. Thanks, -Joel |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sounds in Excel
Thank-you Sir!
"Chip Pearson" wrote in message ... Joel, Yes, you can use an API call to play a wav file. See http://www.cpearson.com/excel/excelM.htm#PlayWAV for details. -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "J. Vandenberg" wrote in message om... Is there any way to get excel to play wav sounds on events? I noticed that the standard VB functions for sounds are not available in the VBA help section, was just wondering if you could call a windows api to do it or something. Thanks, -Joel |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sounds in Excel
By the way, I did a search for this but didn't find the articles
attached. Must have done something wrong, thanks again for answering an old quesiton. One follow up I have (as long as I am typing) I noticed that when it is executing the sound, that the code waits for it to finish, I was hoping that since it was a call to an api that it would make the call and move on. Is there a way to have it sort of "let go" of it and continue on and let the api play the sound without having to finish it to get to the next line? Hmmm... Does that make sense? Your help is greatly appreciated. -Joel "Chip Pearson" wrote in message ... Joel, Yes, you can use an API call to play a wav file. See http://www.cpearson.com/excel/excelM.htm#PlayWAV for details. -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "J. Vandenberg" wrote in message om... Is there any way to get excel to play wav sounds on events? I noticed that the standard VB functions for sounds are not available in the VBA help section, was just wondering if you could call a windows api to do it or something. Thanks, -Joel |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sounds in Excel
You can play the sound asynchronously. See the first article for the
argument to supply the API: http://support.microsoft.com/default...kb;en-us;86281 HOWTO: Play a Waveform (.WAV) Sound File in Visual Basic [Contains the Constants for the Arguments] http://support.microsoft.com/default...b;en-us;158140 XL: How to Play Sounds Using Visual Basic for Applications http://support.microsoft.com/default...b;en-us;149777 XL: How to Play a Warning Sound If Critical Value Is Exceeded http://support.microsoft.com/default...b;en-us;170730 WD: How to Play a .wav Sound File by Using a Macro http://support.microsoft.com/default...b;en-us;211842 WD2000: How to Play a .wav Sound File Using a Macro -- Regards, Tom Ogilvy "J. Vandenberg" wrote in message om... By the way, I did a search for this but didn't find the articles attached. Must have done something wrong, thanks again for answering an old quesiton. One follow up I have (as long as I am typing) I noticed that when it is executing the sound, that the code waits for it to finish, I was hoping that since it was a call to an api that it would make the call and move on. Is there a way to have it sort of "let go" of it and continue on and let the api play the sound without having to finish it to get to the next line? Hmmm... Does that make sense? Your help is greatly appreciated. -Joel "Chip Pearson" wrote in message ... Joel, Yes, you can use an API call to play a wav file. See http://www.cpearson.com/excel/excelM.htm#PlayWAV for details. -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "J. Vandenberg" wrote in message om... Is there any way to get excel to play wav sounds on events? I noticed that the standard VB functions for sounds are not available in the VBA help section, was just wondering if you could call a windows api to do it or something. Thanks, -Joel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I PUT SOUNDS IN EXCEL | Excel Discussion (Misc queries) | |||
| Excel Sounds | Excel Discussion (Misc queries) | |||
| sounds in Excel | Excel Discussion (Misc queries) | |||
| Excel Sounds | Excel Discussion (Misc queries) | |||
| Excel XP x Playing Sounds | Excel Programming | |||
Hybrid Mode
