Can a .WAV file be included in a Spreadsheet?

**rmikulas** · 09-10-2010, 01:48 PM

Hi All!!

I was wondering if anyone knew if a .WAV sound file could be included in a spreadsheet?

Example: I have many different recordings customers have left for us regarding our Technicians. I wanted to be able to come up with a spreadsheet that includes the customer's Work Order info [ie Work Order #, Account #, Tech name (that serviced the customer) etc] and then on the final column I would like to include the .WAV file of the customer's feedback about our Technician.

I have tried to select the INSERT tab and under the TEXT section, select OBJECT, and then on new window that pops up, click on CREATE FROM FILE.
This does insert the file, but its like a picture almost. I mean it does play the WAV file if you click on it, but if i resort my data, the WAV files don't move like if is regular data.

Any help will be great!

Thank you all in advance!

**JBeaucaire** · 09-10-2010, 02:10 PM

I recommend you do some research on Excel VBA Play Sound File and learn how to play external sound files from inside Excel. This will allow you to put sound file names in your "link" column and play them by clicking the links. There are many many possible solutions if you Google them.

**robomike** · 09-10-2010, 02:18 PM

Did you want it IN the spread sheet or IN PLACE of a spread sheet? The top tool bar had the inset that I'm refering to.

**rmikulas** · 09-10-2010, 02:53 PM

@JBeaucaire - Thank you. I will do more research.

@robomike - I just wanted to place the sound file IN the spreadsheet to go with other data, so that when I resorted it, it would move with the rest of the data in the column. I plan on putting a WAV file in every row with other data.

**rmikulas** · 09-10-2010, 02:57 PM

Oh, I'm soooo sorry, I figured it out. ... It was a simple fix. The problem was that when the OBJECT was created it was much larger than the cells. So I just made the object very small to fit in the cells, now when I sort, it moves with the rest of the data.

Wow... sorry all about that. But I got it now