hexagon logo
Register Sign in
  • State Not Answered
  • Replies 12 replies
  • Subscribers 36 subscribers
  • Views 3107 views
  • Users 0 members are here
Options
Related

Basic Script for Execution

Matt Eades

Hello all,

Before I spend a bunch of time digging into this I figured I would reach out to the community fist.  Somebody may already have created the kind of script.  My company has decided to get away from Datapage since it is no longer supported.  All reports end up put into an excel file, so that is my end goal.  I want a script that will execute all dimensions (all dimensions in a single execution).  I will simply place that at the end of our thousands of existing programs with the excel form report.  This would give me the ability to not have to install excel on 12 machines utilizing the excel form report within DMIS.  (already have a manipulated script that maps everything out to an excel file)  I just want to be able to execute the script and excel form report code together, so there is always full complete report uploaded.  I want the operators to be able to correct any errors as needed while running and then always include a complete report so we are not combining multiple reports together or appending the single report.  To put simply I just want the ability to create every dimension in the same execution (dimensions only).

Regards,

Matt Eaders

Parents
  • 0

    I have something like this. It's not too difficult to do, and excel VBA gives you an insane amount of customization... You can make it really cool with logos and color schemes etc. 

    Basically the gist is it's not too complicated; you have to loop through every feature and check if it has a toleranced dimension, if so you add a row/column (however you lay it out). Took me quite a long time and it's "company property" so I won't share it. Trial and error will get you there. 

    Please, don't make your program run through 8 dialog boxes at the start. It's disgusting and if your operators are like mine it will waste hour after hour. Just have one input box for the lot# to save the file somewhere consistent.

Reply
  • 0

    I have something like this. It's not too difficult to do, and excel VBA gives you an insane amount of customization... You can make it really cool with logos and color schemes etc. 

    Basically the gist is it's not too complicated; you have to loop through every feature and check if it has a toleranced dimension, if so you add a row/column (however you lay it out). Took me quite a long time and it's "company property" so I won't share it. Trial and error will get you there. 

    Please, don't make your program run through 8 dialog boxes at the start. It's disgusting and if your operators are like mine it will waste hour after hour. Just have one input box for the lot# to save the file somewhere consistent.

Children
  • 0 in reply to Ed K

    +1 regarding dialog boxes - anything that can be messed up, will. Reducing operator input is a great reason to get a CMM in the first place, so requiring multiple inputs tends to cause more problems than it will solve. Forms, VBA, and special programming techniques are preferred specifically to get rid of these! More work on the programmer up front, but a better result overall

© 2025 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement