Code Monkey

Today was a code monkey day. With my boss out of town most of this week things should be quiet. I was planning on running some gin trials Tuesday and Wednesday, but I need to calibrate a sensor and the guy with the calibration materials was out today....so it is pushed back a day. Instead I spent the morning trying to figure out the calibration process, this necessitated a couple of phone calls to the manufacturer who was not sure how to do it either. Luckily, the manufacturer did call me back and give me a little bit of information.
I spent the rest of my dad alternating between reading the history of cotton dryers (woohoo!) and trying to write some code to automate data handling. I have a few thousand (ok, well over 10,000) semi-colon delimited files that need to be imported into Excel and have a certain range of data formated and put into Excel while the rest is dumped. I spent a few hours plugging away at it. I now have a section of code that will import all of the files automatically, but each file gets put on its own worksheet in the same workbook. This is close but not quite what I want. Now, I need to cut the range of cells I want from each worksheet and put them each in their own column on the same worksheet. I did manage to create a second bit of code that will open the file and only enter the one range of cells I want, however it can't do both. I really need it to do both.
This is something I have wanted done for a long time, but never had time for in NO. If this works out I have an idea for a paper or two utilizing the crap pile of data we gathered over the last few years.