Consecutive Data

[[Ch...]]

Can someone remind me how to export multiple consecutive measurement cycles into one document without have QC Calc or Pi-Web going?

I remember there was a settings somewhere that allowed for placing them all into one Excel sheet.

[[Ow...]]

Doesn't mean there is not a way to do with Calypso (?) but, to my knowledge, not automatically.
I've attached the Excel Merge macro.

This is an excel macro that will combine the results from all CALYPSO excel reports in a single folder. Customers like to see all their results in one file for one reason or another and this Excel macro is an easy way to do it.

The instructions are below.

1. Create a folder called "C:/tmp"
2. Put your files inside the folder "C:/tmp"
3. Open up the "Sort_Zeiss_Data_Macro_File.xls" found above (in same custom printout folder as this document is, its an excel doc)
4. Note: Make sure your macros are enabled inside Excel
5. Click on the "Combine Files" button
6. Enter in the file path of your result files, in this case "C:/tmp"
7. Your results are then displayed

Excel_Merge.xls

[[Er...]]

We use Excel Power Query Editor. Take the relevant .chr files and put them in a folder on the Windows Desktop. Open Power Query Editor and select that folder as a New Source. Use Tab Delimiting etc. Save and Close the Query. Use PivotTables to pull the data.

[[Ch...]]

Thanks, I'll try that Excel macro. I just remember seeing a Zeiss Application engineer check a box and when the Excel was exported it showed all the previously ran part data...

[[Er...]]

I'm sure there is a way to automate it. I'm just not an Excel VBA programmer.