[Je...] Posted July 17, 2020 Share Posted July 17, 2020 Hello. My company has tasked me with getting Calypso to output results into a specifically-formatted excel file. From here, they can import the file into our document control software. I don't know how to do this, and I could use some help. I know how to get Calypso to output to the generic excel template that comes with the software, and I can make minor tweaks to this template. However, I don't know VBA (excel code), and I don't know how to achieve the result my company is asking for. I've attached the excel file that is being requested. It's very simple. Otherwise, here's a screenshot of it. Thanks for the help! excel import template.xls . Jeff Frodermann CMM Programmer Windings, Inc. D: 1-507-225-1114 | TF: 1-800-795-8533 PO Box 566 | 208 N Valley Street New Ulm, MN 56073 . Link to comment https://qualityforum.zeiss.com/topic/15092-excel-file-output-question/ Share on other sites More sharing options...
[Cl...] Posted July 17, 2020 Share Posted July 17, 2020 IM me your e-mail and I'll send you a video that shows you how to do just that. Link to comment https://qualityforum.zeiss.com/topic/15092-excel-file-output-question/#findComment-80872 Share on other sites More sharing options...
[Je...] Posted July 20, 2020 Author Share Posted July 20, 2020 Thanks, Clarke. I sent you my email address via IM. That video would be very helpful. Link to comment https://qualityforum.zeiss.com/topic/15092-excel-file-output-question/#findComment-80874 Share on other sites More sharing options...
[To...] Posted July 23, 2020 Share Posted July 23, 2020 This may be of some help. Copy the attached MASTER_EXCELREPORT.xls and ReportINI.xls files in the desired folders. After the CMM inspection is completed, move or copy the generated Excel reports into a new folder. Then open the Data Compiling MacroFile.xls and copy and paste the path of the inspection report Excel files. Link to comment https://qualityforum.zeiss.com/topic/15092-excel-file-output-question/#findComment-80876 Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in