Play .WAV File and run macro simultaneously

[Yappa]

Hi all,

Just wondering if it's possible to play a .WAV file and not have to wait for it to finish before a macro can run, or even play a .WAV file and not have to wait for it to finish to perorm normal manual tasks.

I have a code which is from www.cpearson.com and runs the .WAV file, but am confronted with this issue.

Please Login or Register  to view this content.

Can anyone help?

Thanks,

Yappa

[Andy Pope]

For Chip's code you need to set the flag value.

Please Login or Register  to view this content.

Another example can be found on John Walkenbach's site
http://www.j-walk.com/ss/excel/tips/tip59.htm

[Yappa]

Thanks Andy that works perfect. Just wondering if you could explain what's happening with this part of the code:

Please Login or Register  to view this content.

If not, appreciate your help anyway.

Yappa

[Andy Pope]

It's simply declaring the function contained within winmm.dll
so the compiler knows about it.