VBA to start a hyperlinked audio file

[chaconne]

I have a form with hyperlink field which contains the file name of an audio file in a folder of audio files.

I currently click on the hyperlink field to start the relevant audio file.

I would rather have a command button which starts the audio file.

I would be very grateful if someone could kindly tell me what the VBA code would be for this.

 

[Beetle]

It's a bit dated, but you might find some helpful info on the subject here. Look for the link titled;

November 2004: Sounds good to me and Stupid Date Tricks

There is a downloadable sample application.

 

[chaconne]

Thanks Beetle that is really very helpful.