I've always used what you have there to play sounds other than the inbuilt. Basically you're asking to do something that is fairly advanced as far as Access is concerned, so the short answer is (as far as I'm aware) no, there is no way to do what you're asking via a macro. Of course I'm also not very well versed with macros as I always use code, so maybe someone knows better than I do.
There's nothing you can do with a macro that you can't do with code, but the converse isn't true. And in my opinion, once you learn the syntax at least, coding is much easier and faster than macros. So once you learn VB, you'll never look back.