MrExcel Publishing
Your One Stop for Excel Tips & Solutions

importing wav-files


Posted by Carsten Stroh on October 28, 2001 10:49 PM

Hi,
I'm looking for a macro that can import WAV-files into excel. I'd like to get the amplitudes so that I can visualize the waves and calculate with the data.


Posted by Damon Ostrander on October 29, 2001 7:43 PM

Hi Carsten,

You can read the data using VBA I/O. See the VBA helps for the Input statement, which allows you to read a wav file byte-by-byte. You will have to know and understand how wav files are formatted to be able to interpret the data. If you do not already have this information, I'm sure there are lots of places on the web where wav file format definitions are posted.

I hope this helps.

Damon