I have a program that reports several Xactmeasure line profiles. I have to put the max/min values of each profile into a spreadsheet. Right now I do that by hand. I'm looking for a way to automate the process using a script. I have a script that I use to extract nominal and measured values for points and am thinking I can modify it but I have no idea how to "find" the Xactmeasure profile dimensions in my program within the script. Any ideas?
If you activate showing MAX/MIN (F10) and use
File -> Export -> Text... both the MEAS, MAX and MIN of a profile FCF will be in the text file. The format of this file is like CSV, so it can be opened more or less directly in Excel and massaged by an Excel macro to move the correct values to the correct places in a destination worksheet.
Unfortunately this kind of export can't be automated (as far as I know), you have to do the menu choices manually. Maybe the menu activation can be automated from Excel, so you might get by with only one button click in Excel after each part is measured, but I don't know that for sure.
If you activate showing MAX/MIN (F10) and use
File -> Export -> Text... both the MEAS, MAX and MIN of a profile FCF will be in the text file. The format of this file is like CSV, so it can be opened more or less directly in Excel and massaged by an Excel macro to move the correct values to the correct places in a destination worksheet.
Unfortunately this kind of export can't be automated (as far as I know), you have to do the menu choices manually. Maybe the menu activation can be automated from Excel, so you might get by with only one button click in Excel after each part is measured, but I don't know that for sure.
