These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Wednesday, April 13, 2011

Aggregate and Organize from Multiple Files

The Food Science department uses a piece of equipment that analyzes different foods and creates hundreds of CSV files of output Each CSV is placed in a folder by the machine. For many months they have paid students to do the following:
  • Open the folder containing the CSV.
  • Open the CSV.
  • Go to the last worksheet.
  • Copy the entire range (three separate ranges)
  • Paste the range in another worksheet
  • and then repeat the process for hundreds and hundreds of folders.
My project automates this process, shortening the amount of time from 30 hours to 2 seconds, and reducing the chance of error.

Output Files From Machine (must be unzipped)

Excel Aggregator (thoroughly documented code)





No comments:

Post a Comment

Blog Archive