G'day tracks,
You may have already found the answer to this, but here's one that I found.
First, insert your sound into a worksheet that will not be used (except, perhaps, to store other sounds) - I also copied the sound file into the same folder as the workbook as per insructions on the other forum. Make sure you write down the object number (if you don't know, by opening up vba after the next step, you can see its name there).
Next, record a new macro, then play the file, then stop the recorder.
The next step is one where I'm not sure it's optional as I just followed the instructions I found on another forum. Hide the worksheet with the sound.
Now, open vba and copy the lines of the macro code into the vba code where you want the sound to play.
Next, alter your code so that it looks like this (and keep it to one line only by joining the two lines and deleting/adding vba code accordingly):
Code:
Sheets("Sounds").OLEObjects("Object 2").Verb Verb:=xlPrimary
"Sounds" is the name of the hidden sheet containing the wave sound.
"Object 2" is the name of the object pasted into the hidden sheet when you inserted the sound.
Now, run your code and it should work. I don't know enough about vba to answer the question as to why the sound doesn't work when the recorded macro is pasted into vba, but I eventually found that the above line worked.
Regards,
Mitch