Consolidating files logic


There is one master file (or sheet) which needs to be consolidated by pulling data from multiple source files containing raw data (having the same data structure). If you are new to VBA, Excel macros, go thru these links to learn more.

Sub Get Data() Dim str Where To Copy As String, str Start Cell Col Name As String Dim str List Sheet As Stringstr List Sheet = “List” On Error Go To Err H Sheets(str List Sheet). Select ‘this is the main loop, we will open the files one by one and copy their data into the masterdata sheet Set current WB = Active Workbook Do While Active Cell. If you want to learn how to develop applications like these and more, please consider joining our VBA Classes.

#1: CHECK ALL EDITS: Make sure that all edits are good, take the time before you consolidate the files to really listen to the edit points to check for clicks, weird transitions, anything that might cause attention to be drawn to the edit.

#2: REMOVE ALL PLUGINS and AUTOMATION: If you use any plugins please make sure that they are removed or bypassed before exporting your files.

We then switch back to our main workbook and select the sheet where we want to paste the data, I have assigned this to the variable called “str Where To Copy”.

Open str File Name, Update Links:=False, Read Only:=True Set data WB = Active Workbook Range(str Copy Range). We open the data workbook by using the Application. Next we select the data that has been assigned to the copy range and copy to the clipboard.

I have also made use of UDF (user defined function) to find the last cell in the column that we specify.

This allows us to paste data onto separate sheets within the same workbook.

If the “audible” part of the signal (the part above the noise floor) changed depending on whether the signal was represented as a 32 or 24 or 16 or 8 bit word, this change in the waveshape would produce harmonics not present in the original signal, (aka "aliases”). If your recording was made using microphones, preamps, softsynths or samples, the inherent noise floor is already 100 times higher than the noise floor of dithered 16 bit audio, and properly dithered digital audio has infinite resolution. you're not "missing" anything by truncating and dithering to 16 bits.So I may have 20 to 40 total song tracks, and each one may contain anywhere from 2 to 5 or even 6 channels to create the final product on one channel.There just has to be a faster way then recording it all in real time right?It's a great tool for combining data when several users work with different instances of the same file.But don't cross this feature off your list because it sounds like something you don't need.Assuming you're not just switching between DAWs on the same machine, it's easy and inexpensive to use an external hard drive, and even USB pen drives are now typically large enough to hold a full project (just don't try to run the project directly from it!

You must have an account to comment. Please register or login here!