Need to play a wav file based on path and filename in a selected cell using macro: SOLVED!

**needtoregistersux** · 03-31-2016, 03:21 PM

I've been trying to figure this out on my own, and I'm stuck. Just can't get the macro to work.

I have a csv file in open in excel with a column that contains the partial path and filename of wav files (e.g. "dira\new\boom.wav"). The root of the path will always be "C:\sounds\". I want to add a macro to my PERSONAL.XLSB workbook so that I can add a button to a custom ribbon for the macro that will play the wav file in the currently selected cell. That way I can keep the file in csv format, and can use the same macro on other csv files which will also have path\filenames in the same column, and have the same root path.

Can someone please help me and let me know how to do this? So far all I've been able to do is get a macro to play a beep instead of the wav file in the selected cell.

Thank you!

**AlphaFrog** · 03-31-2016, 04:10 PM

Please Login or Register  to view this content.

**needtoregistersux** · 03-31-2016, 06:04 PM

Originally Posted by AlphaFrog

Please Login or Register  to view this content.

Thanks! This works... but not always. For some reason, sometimes the sound will play. Other times, it will just play a short beep. This is even happening with two sounds in the same folder, with the same sample rate & bit depth, both stereo wav files of about the same length. No idea why one will play and the other wont. Any ideas?

**needtoregistersux** · 03-31-2016, 06:51 PM

Also, I had to modify the declare with PtrSafe to get it to work. I am using Excel 2010 on a Windows 10 PC. I'd really love to know why the beep plays sometimes instead of the wav file, because the files definitely do exist, and are the same format as a number of other files that do play in the same folder, with the exact same attributes. Really frustrating that some just don't play while others do. No clue why.

Please Login or Register  to view this content.

**AlphaFrog** · 03-31-2016, 07:00 PM

Originally Posted by needtoregistersux

Thanks! This works... but not always. For some reason, sometimes the sound will play. Other times, it will just play a short beep. This is even happening with two sounds in the same folder, with the same sample rate & bit depth, both stereo wav files of about the same length. No idea why one will play and the other wont. Any ideas?

I have no idea. Sorry.

Try this. Just a shot in the dark.
sndPlaySound strFile, 0

**needtoregistersux** · 03-31-2016, 07:12 PM

Yeah changing it to 0 didn't work. Darn. So close. I sure hope someone knows why this is happening.

**needtoregistersux** · 03-31-2016, 07:15 PM

Adding the following at least stops the beep from playing.

Please Login or Register  to view this content.

Thus making the flag a 3.

Please Login or Register  to view this content.

**needtoregistersux** · 03-31-2016, 07:27 PM

Eureka! I discovered the cause of the problem!

I've had issues with this in the past, so thought to take a look and see. Opening a few of the files in notepad, I was able to see that the ones that played were "RIFFŽ«; WAVEfmt" in the header, while those that don't play are "RIFF¢0 WAVEJUNK\", which are wav files exported from Pro Tools.

After touching the files in Sound Forge and saving them, they play just fine using the macro!

Yet another reason to hate Pro Tools. LOL!

**AlphaFrog** · 03-31-2016, 07:33 PM

Excellent! Thanks for the feedback.

**needtoregistersux** · 03-31-2016, 07:47 PM

No problem. Glad I could give something back. Thank you for helping me to get this working! It's going to be a major time saver in my workflow.

Need to play a wav file based on path and filename in a selected cell using macro: SOLVED!

LinkBack

Thread Tools

Rate This Thread

Display

Need to play a wav file based on path and filename in a selected cell using macro: SOLVED!

Re: Need to play a wav file based on path and filename in a selected cell using a macro

Re: Need to play a wav file based on path and filename in a selected cell using a macro

Re: Need to play a wav file based on path and filename in a selected cell using a macro

Re: Need to play a wav file based on path and filename in a selected cell using a macro

Re: Need to play a wav file based on path and filename in a selected cell using a macro

Re: Need to play a wav file based on path and filename in a selected cell using a macro

Re: Need to play a wav file based on path and filename in a selected cell using a macro

Re: Need to play a wav file based on path and filename in a selected cell using a macro

Re: Need to play a wav file based on path and filename in a selected cell using a macro

Thread Information

Users Browsing this Thread

Similar Threads

Find filename and path of a linked file in another cell

Macro to open a file and folder that has date in the path based on a cell value

Find File with partial filename and get path of folder

Extracting the folder name and filename from a file path?

[SOLVED] Excel Macro: How to open a file with selected path?

Run Macro on cell change to update path and filename for query

Play wav sound when cell is selected

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions