Please excuse me for being such a newbie and for this being so long. I've taken a MS approved intro course to VB.NET but I still don't know exactly what is possible. At work we have an Excel sheet that uses a lot of VB script and a report template. I want to try to turn this into a VB.NET app as my first "project". Background: We have a machine that measures sound in a production environment. This machine needs to be calibrated periodically. To do this we take a calibrated instrument and measure those same sounds. We do this in 5 locations. This generates 5 files in ASCII format. Each file contains some header information and then 1024 measurements. Each measurement is a different frequency and there is an associated db level. What Excel does is this: Queries the user with an open file dialog to select the 5 measurement files. Uses a couple of values in the header of the first file and puts 5 x 1024 measurements in a scratch sheet. It then does some averaging on those values, goes out on the network to the machine in the location just measured and pulls in the last calibration, and displays a line graph comparing the new measurements with the old calibration. If this information is satisfactory, you click a button to "use" the new measurements as a calibration and a data file is written over the network to the machine as it's new cal file and the report template fires up to generate a 2 page statistical report and graph of the new data.
The part I'm lost at is the Excel scratch sheets. How do I open up these 5 files and manipulate them in VB.NET in a stand alone .exe (with no Access DB or SQL Server dependency)?
Thanks for bearing with me through this.
The part I'm lost at is the Excel scratch sheets. How do I open up these 5 files and manipulate them in VB.NET in a stand alone .exe (with no Access DB or SQL Server dependency)?
Thanks for bearing with me through this.