I found some help on the web of examples and I think my difficulty is I'm trying to do something maybe a bit out of the scope of what VBA should be used for, or I just can't think "windows" very well.
The Project: Create an semi-automated data analysis tool to read in pre and post exposure datalogs (text files) from a number of (semiconductor product) testers (all in different formats) and apply some statistical analysis (which excel can do) to determine at what level of exposure parts began to fail.
So there already exists a VBA excel program that will read in a number of these datalog formats and my hopes were to use what is already written and just add on to it. Unfortunately the datalogs I'm working with right now are not covered by this already written tool. So I need to add them to the list of files that can be handled before I can begin with my part of the project, the statistical analysis.
In my minor programming experience (6 college classes) VBA really doesn't seem like the best way to do it, but sometime substantial is already started in it. I have no qualms about recoding this thing in another language, but all I've ever really used was C++, and for text handling it also doesn't seem the way to go. So, I feel a bit stuck.
|