Playing embedded WAV files from excel.

**swoop99** · 04-09-2012, 06:08 AM

While providing some help from another user on here I came across the following code which will play a .wav file from VBA without launching any third party apps (like winamp or windoze media player):

Please Login or Register  to view this content.

And it works well.

However, I'd like to embed the wav files in question into my workbook and play them from there without having to make a user download them as separate files. So....I looked around and found the following:

Insert > Object... > Create from File > C:\Folder\filename.WAV

and then play it by either:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

The problem with both the methods of playing the embedded file is that it will try to launch the systems default .wav file player. This means the user will get a message saying "Do you want to open this" and if the default wav player is winamp and (like mine) is set to repeat the playlist, the wav isn't just played once.

Is there any way to combine to two methods above? ie, have the .wav file embedded in a workbook but play it using the "sndPlaySound" method which doesn't launch an external .wav player?

I've tried replacing the file location with activesheet.shapes("object 1") but get a "doesn't support this method" error.

**ukyank** · 07-10-2019, 06:27 PM

Its been a while since you posted this and I was looking for the same thing. Any chance you sorted this out?

**LuBuExc** · 08-08-2019, 05:21 AM

Hi, I'm aware that this question has been posted a long-time ago. Now the systems are 64 bit and when I try to run this code I get: "Compile error: The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute". I don't know how? I'd like to play wav mp3 and possibly other audio formats inside Excel. Can anybody help? I'm pretty new in the field of VBA in Excel.

**dominicb** · 08-08-2019, 05:25 AM

Good morning LuBuExc

Untested, as I don't have Office 64 bit,but try this :

Please Login or Register  to view this content.

If this doesn't work, then please open a new thread on the subject.

HTH

DominicB

**LuBuExc** · 08-08-2019, 06:57 AM

Thanks DominicB.
The declaration part seems now to be fine, but it stops in the sub playit.
"My" code is now:

Please Login or Register  to view this content.

It stops at sndPlaySound and says Compile error: Sub or Function not defined.
Probably I'm doing something very stupid. If we can't solve I'll try a new thread as you suggested. Thanks LuBu

**dominicb** · 08-08-2019, 07:08 AM

Hi LuBuExc

Try the amendment below :

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

Next time you post, please remember you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I have edited your post to include code tags.

**rorya** · 08-08-2019, 08:39 AM

The 64bit equivalent of the original would just be:

Please Login or Register  to view this content.

Change highlighted. PlaySound is actually a different function and takes three arguments.

**LuBuExc** · 08-08-2019, 08:51 AM

Thanks DominicB. Unfortunately it still doesn't run. It stops at PlaySound in the Sub and says: Compile error: Argument not optional.
Any further ideas for me? Best regards LuBu

**dominicb** · 08-08-2019, 08:55 AM

LuBuExc

Have you tried rorya's suggestion?

HTH

DominicB

**LuBuExc** · 08-08-2019, 08:59 AM

Thanks rorya. This now works. I add the working code now.

Please Login or Register  to view this content.

**LuBuExc** · 08-08-2019, 09:08 AM

Thanks again to rorya and dominicb. The posted code works for wav files. I have tested and run with various. Is there also a solution for playing mp3 or even m4a in a similar manner?

**FDibbins** · 08-08-2019, 09:26 AM

Originally Posted by LuBuExc

Thanks again to rorya and dominicb. The posted code works for wav files. I have tested and run with various. Is there also a solution for playing mp3 or even m4a in a similar manner?

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

**rorya** · 08-08-2019, 09:31 AM

IIRC you can use mciSendString to launch whatever the default player is, but I don't know if there is an API that will play either of those formats directly.

Playing embedded WAV files from excel.

LinkBack

Thread Tools

Rate This Thread

Display

Playing embedded WAV files from excel.

Re: Playing embedded WAV files from excel.

Re: Playing embedded WAV files from excel.

Re: Playing embedded WAV files from excel.

Re: Playing embedded WAV files from excel.

Re: Playing embedded WAV files from excel.

Re: Playing embedded WAV files from excel.

Re: Playing embedded WAV files from excel.

Re: Playing embedded WAV files from excel.

Re: Playing embedded WAV files from excel.

Re: Playing embedded WAV files from excel.

Re: Playing embedded WAV files from excel.

Re: Playing embedded WAV files from excel.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions