Click a Button, Play a WAV File (for the Dull of Wit)

[ProvPC]

I've been struggling with this seemingly simple operation for two days now, and I just can't seem to get it. I've read and done my best to follow numerous examples given - many within this very forum - and have encountered an extraordinary variety of error messages in the process (and sometimes, no error messages at all, but also no results).

I have a 64-bit version of Excel 2016. I'm trying to create a button that will do two things:
1) Increment the value in a given cell by 1
2) Play a sound. Extra points if this part doesn't necessitate the launch of a separate program, but I'll take what I can get!

The file needs to be portable, but I am not bothered by whether it's easiest to embed the audio file, or to summon it from the same directory the spreadsheet inhabits - whatever you feel works best, I'll be delighted with! I'm just requesting some clear, precise instructions on how to get the silly thing to work. )

I wish I'd kept a list of all the error messages, but they've included things like needing to optimize and add the PtrSafe function for 64-bit, value undefined, Public declarations not allowed, cannot locate insertion point, and just plain nothing at all (least of all audio!)

Any assistance would be much appreciated!

 

[ProvPC]

Sorry - there is NO sound is what I meant to say.

 

[ProvPC]

On a lark, I started a new workbook, and repeated the steps above on an otherwise empty workbook. Again, the increment updated, but this time there's a "ding" every time I click the button - like an error alert or notice - but nothing appears to show me what the complaint is.

 

[ProvPC]

Well... the sound works perfectly on a different PC running a 32-bit version of Excel 2013 , with or without the PrtSafe declaration. I can only assume there's something wrong with the 64-bit part of the declarations? Or something wrong with my version of winmm.dll (which seems unlikely). I have a 64-bit version of Excel 2016.

 

[pbornemeier]

If it runs on 32-bit Excel, adding PtrSafe to the declaration should allow it to run on the 64-bit version. Is there another machine with the 64-bit version available for test?

 

[ProvPC]

If it runs on 32-bit Excel, adding PtrSafe to the declaration should allow it to run on the 64-bit version. Is there another machine with the 64-bit version available for test?

Sadly, there is not - though I'd be willing to upload the workbook somewhere if someone with a 64-bit version of Excel 2016 could test it for me. (And it would be hilarious to discover that this entire time I've been beating my head against the wall because of something OTHER than my poor VBA skills!)