Previous | Next | Sheffield
Topic: Output data from FLB3 programs to EXCEL
Conf: Sheffield, Msg: 2438
From: Shane Earl (sfearl@earthlink.net)
Date: 1/7/2001 08:16 PM

Hello, Jim. Although I'm using antique DEA Tutor (DOS) software, I'm facing a similar problem. If you've already tried using the standard Excel Text Import Wizard and found it lacking, you could conceivably write a VBA (Visual Basic for Applications) macro to bring the CMM data into a spreadsheet. This is the route I've chosen, but I'm gathering input from all of our Quality Engineers in an effort to create a full-blown Dimensional Inspection Report using the imported CMM data. I'm doing this in my spare time, so it's going to take awhile. If/when I finish, I'll publish the code as freeware.

If you or anyone you know of can program in BASIC, I'd recommend you look into this approach if you find that no one else has written anything similar to it for your CMM file type. You could even contract the work out to an experienced VBA programmer if you don't have anyone "in-house" to do it. Also consider a simpler approach which instead of inserting data into spreadsheet cells would simply rewrite the CMM data as a CSV file. Hope this helps.

Shane