mattding
Mechanical
- Jul 29, 2005
- 5
I am programming parts for our Coordinate Measuring Machine, in MCOSMOS 2.4, for a Mitutoyo CMM. I can output the results in numerous ways, including PDF and an appended ascii file. I can also direct to Excel. If more than 1 part is checked, it appears that only the 1st data set is created in Excel.
I want to be able to create an Excel template of sorts that will allow Excel to automatically open the created appended data set, decide how many sets of data there are, and load into the appropriate cells in order to create a formatted report. The data sets will probably be from 1 to 10, and there could be as many as 20 - 25 dimensions per data set.
How do I set a monster like this up? I think that it has to be slightly intelligent. I can possibly go into the appended data set file (ascii) and add some data such as number of data sets, total number of dimensions per set, and file name/path to find data, but I would rather be prompted or just have to fill in a few cells to tell the spreadsheet what to do.
Someone else other than I will be loading and measuring the parts, so it has to be fairly easy to understand.
I have never written a macro before, created a template, ar am versed in VB.
Any ideas?
I want to be able to create an Excel template of sorts that will allow Excel to automatically open the created appended data set, decide how many sets of data there are, and load into the appropriate cells in order to create a formatted report. The data sets will probably be from 1 to 10, and there could be as many as 20 - 25 dimensions per data set.
How do I set a monster like this up? I think that it has to be slightly intelligent. I can possibly go into the appended data set file (ascii) and add some data such as number of data sets, total number of dimensions per set, and file name/path to find data, but I would rather be prompted or just have to fill in a few cells to tell the spreadsheet what to do.
Someone else other than I will be loading and measuring the parts, so it has to be fairly easy to understand.
I have never written a macro before, created a template, ar am versed in VB.
Any ideas?