Excel 2007 : Code to play wav file.

**GaidenFocus** · 11-10-2010, 06:21 PM

Ok i have done alot of research today, and i tried 3 or 4 different codes and none of them have worked. sometimes i get a compilation error and others just execute the macro as if the code wasn't even there.

here is the setup:

i have a control button on a sheet that when clicked shows a userform, that asks for tag id and qty. this updates another sheet and when its done shows another user form with a success message. when this message pops up i would like it to play a wav file (its from borat when he says GREAT SUCCESS!)

any ideas on how to get a wav file to play from a user form control?

**JBeaucaire** · 11-10-2010, 08:55 PM

In this thread I showed an OP how to play some sounds on button clicks, much the same as a userform. Take a look:

http://www.excelforum.com/excel-gene...m-tasks.html#5

**GaidenFocus** · 11-11-2010, 10:52 AM

ok it allowed me to play the tada sound, but i put the "GreatSuccess.wav" file in the media folder, and then changed tada to greatsuccess but it doesn't play it.

**JBeaucaire** · 11-11-2010, 11:20 AM

Only thing I can think of is you found the wrong media folder...?

**GaidenFocus** · 11-11-2010, 02:07 PM

c:\WINDOWS\MEDIA

oh well... it was a dream, but i guess now that dream is dead.

**JBeaucaire** · 11-11-2010, 02:51 PM

Backup the TADA.wav file somewhere else, then remove it from the media folder.

Rename your desired sound file as TADA.wav and put in that folder. That could do it.

**GaidenFocus** · 11-13-2010, 02:14 PM

yea i already tried that before i replied. didn't work EXCEPT i didn't backup the tada file. haha..

**JBeaucaire** · 11-13-2010, 02:32 PM

Well, if it was playing the tada file and then you replaced the tada file with something else also named tada but it didn't play that, then you've got something going on in your OS.