Can't find "PlaySound" function

[GraeagleBill]

Where does one find the "PlaySound" function?

Seems most of what I find with Google are very old posts that only reference an API but I seem to recall VBA had advanced beyond that?

Bill

[pbaldy]

This worked for me just now:

http://allenbrowne.com/func-04.html

[GraeagleBill]

Yes, I did see Allen's post but compiler complains it can't find the function

Playsound ("C:\eRep\NielsenShort.wav")

Perhaps missing a reference?

[isladogs]

You need to copy the API code to a module - see same link- no extra reference needed

[GraeagleBill]

GOOD GRIEF.......... I obviously need a nap!

Thanks guys,
Bill

[isladogs]

Best mute the sound again in that case!