[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 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 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 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 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