Thread
:
Sounds in Excel
View Single Post
#
5
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
Sounds in Excel
Joel,
You can play the sound "asynchronously", meaning that execution will
continue as soon as the sound begins to play rather than waiting for the
sound to finish, by changing the second argument of the function from 0 to
1.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
"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 With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson