import WAV into txt or xls?

[bcameron]

Hi,

I am trying to convert a WAV file into numbers - ie need to convert to either a txt file to import into a xls to do maths on it, fouriers etc.

Could anyone help me please or point me in the right direction to have code in Excel that i can run from my macros to be able to read in a WAV to be able to analyse the data.

Thanks in advance.

Barrett.

 

[random_noise]

I dont think you can just open it with excel etc and get the kind of numbers you are after.

What do you expect the numbers to represent?

You might need to look at MATLab or SpecLab to give you some kind of meaningful output because if you just open a wav in notepad you can see it is encoded.

 

[bcameron]

Hi Dave,

Yea it is a binary file.

I have run routines with Matlab before as it can read in WAV format and was hoping someone had written some code to read in the WAV format into Excel.

I have some code written in VB to import WAV but it wont work in Excel VBA.

I will be doing some Fourier analysis, filtering and binning of the data and making some graphs. I used to do it with MatLab and am trying to do the same in Excel.

Thanks.

Barrett.

 

[random_noise]

Barrett,

Have a look at Speclab http://freenet-homepage.de/dl4yhf/spectra1.html and see if you can use that to create the output text file you need.

Once you've done that it may be simple enough to create a macro which loads it in to excel and processes it as you want it.

I think actually using excel to decode the data will be tricky though, unless you are using some libraries to do the work.

Can you post your VB script that you used before?

 

[bcameron]

Thanks Dave for the link,

i have seen a few programs which will convert WAV to txt and could do the conversion externally as you suggested and then read in the txt.

What i was hoping was to make use of some of the windows dll files as i have seen others do in other threads to import in the WAV into excel as data.

In other posts i have been able to play and record WAV files from excel making use of these winmm.dll and others from code supplied in the forums.

Was hoping for another fix like this.

Barrett.